Where Identity SQL Server 2008 save?
- Thread starter onlove_ol
- Start date
-
- Tags
- identity sql server 2008
195471
Regular Member
- Oct 11, 2008
- 415
- 264
You're not supposed to be seeing "Identity" in the System Tables folder. 
I'm not sure if this is what you're after, but when you set a primary key in SQL Server Management Studio, there's an option to select an Identity:
Column Properties > Identity Specification > (Is Identity) > [select "Yes"]
I'm not sure if this is what you're after, but when you set a primary key in SQL Server Management Studio, there's an option to select an Identity:
Column Properties > Identity Specification > (Is Identity) > [select "Yes"]
System tables wont have any identity column, only user tables can have identity column if you explicitly define it.
Code:
SELECT SCHEMA_NAME( OBJECTPROPERTY( OBJECT_ID, 'SCHEMAID' )) AS SCHEMA_NAME,
OBJECT_NAME( OBJECT_ID ) AS TABLE,
NAME AS COLUMN
FROM SYS.COLUMNS
WHERE [B]COLUMNPROPERTY(OBJECT_ID, NAME, 'IsIdentity') = 1[/B]also you cant directly add/delete/modify data in system tables from 2005 version. From 2005 we cant view metadata,(system tables are hidden from 2005) instead we to query system views,sp
For eg when you create a job or delete a database, it will automatically update system tables is system databases.
For eg when you create a job or delete a database, it will automatically update system tables is system databases.