Where Identity information Stored
-
Hi All,
Here is small question.
Where the identity values and column information stored like how for Procedures, functions, triggers etc.
-
The names and ID's of the objects are stored in the SYSOBJECTS table. The SQL for each is stored in SYSCOMMENTS and the ID in SYSCOMMENTS matches the ID in SYSOBJECTS.
Look in Books Online under "SYSTEM TABLES" for more information on those an other system tables.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
I am not finding any such information regarding identity of column either syscomments or in sysobjects,
suppose If i create a table :
create table mytable ( mycolumn1 int identity(100,1), myname varchar(100)
)
where the identity information for mycolumn int identity is stored ?
-
Look at the table syscolumns at the [status] column.
Or google -- eg:
-
It's amazing what can be found in Books Online and Google when one takes the time to look
--------------------
Colt 45 - the original point and click interface
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply