Auto Number Data Type?

aaronshover · #1 (**permalink**) 07-31-03, 15:08

Is there a data type like Access's auto number that will automatically assign a record a number? I transfered a database from Access 2000 to SQL 2000 and it did not preserve the autonumber datatype.

Memnoch1207 · #2 (**permalink**) 08-03-03, 00:53

Identity is the SQL Server equivalent to the Access autonumber.

aaronshover · #3 (**permalink**) 08-04-03, 08:51

When I open a table in design view and I change a datatype I do not see Identity in the list.

dbadelphes · #4 (**permalink**) 08-05-03, 13:13

Identity is property not a data type.
Chose a INT type for instance, then (in the bottom of the design screen - columns panel) specify if that's an identity column, the seed and increment eventually.

Quote:

Originally posted by aaronshover
When I open a table in design view and I change a datatype I do not see Identity in the list.