Why do we get this Err ?
Are you trying to get an IDENTITY property Info of a Table? - But, The table actually doesn't have any IDENTITY on it!
Ok.
Let me create a new table without any IDENTITY on it
CREATE TABLE dbo.Table1
(
Id Int, Name Varchar(10)
)
GO
Now, I am trying to get the IDENTITY Info of the Table
DBCC CHECKIDENT('dbo.Table1')
Msg 7997, Level 16, State 1, Line 4
'Table1' does not contain an identity column.
Yeah! Actually, we don't have an IDENTITY on this table. Right!
No comments:
Post a Comment