Home Forums SQL Server 7,2000 General IDENTITY Info in System Catalog RE: IDENTITY Info in System Catalog
mromm
SSCarpal Tunnel
Points: 4301
More actions
July 29, 2003 at 2:54 pm
#467604
But how do I figure out if seed and increment were specified explicitly or not?
For example,
CREATE TABLE tbl_1 ( col_1 INT IDENTITY )
versus
CREATE TABLE tbl_1 ( col_1 INT IDENTITY( 1, 1 ) )