Well kind of.

Ok here is the syntax on creating a table in SQL and having an autonumber column

Help with Code Tags

(Toggle Plain Text)

CREATE TABLE NorthWindUsers 
         (UserID INT IDENTITY(1,1) NOT NULL,
          UserName VARCHAR(50) NOT NULL,
          Password VARCHAR(50) NOT NULL)

CREATE TABLE NorthWindUsers (UserID INT IDENTITY(1,1) NOT NULL, UserName VARCHAR(50) NOT NULL, Password VARCHAR(50) NOT NULL)

The userID will start a 1, and increment each time you add a new user to the table; automatically


Hope this helps