SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying System Tables | Journ

Similarly you can find identity column also using $IDENTITY, Declare @t TABLE (GuidCol UNIQUEIDENTIFIER DEFAULT newsequentialid() ROWGUIDCOL, IdentityCol int identity(1,1), data VARCHAR(60) ) INSERT INTO @t (data) SELECT ‘test’ INSERT INTO @t ...

blog.sqlauthority.com