|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: 2 days ago @ 1:47 AM
Points: 99,
Visits: 129
|
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Friday, January 18, 2013 2:22 PM
Points: 162,
Visits: 262
|
|
| SELECT * FROM syscolumns WHERE columnproperty(id,column_name,isidentity) = 1
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: 2 days ago @ 1:47 AM
Points: 99,
Visits: 129
|
|
hello sir,
here my table is ICH...
create table ich(eno int identity(3684215,1),ename varchar(10))
how to find ? tell me?
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 3,129,
Visits: 4,312
|
|
try this (written for SQL2005 / SQL2008)
select objects.name as Object_Name, columns.name as column_name from sys.objects join sys.columns on columns.object_id = objects.object_id where is_identity = 1
____________________________________________ Space, the final frontier? not any more... All limits henceforth are self-imposed. “libera tute vulgaris ex”
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: 2 days ago @ 1:47 AM
Points: 99,
Visits: 129
|
|
Thank you very much sir........
i got the result.....
Your's
Subha..........
|
|
|
|