How do you find out all the IDENTITY columns of all the tables in a given database?

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sunny-138471 Ten Centuries Points: 1162 More actions · Answer 1

SELECT * FROM syscolumns WHERE columnproperty(id,column_name,isidentity) = 1

subha.msc2007 Mr or Mrs. 500 Points: 519 More actions · Answer 2

hello sir,

here my table is ICH...

create table ich(eno int identity(3684215,1),ename varchar(10))

how to find ? tell me?

subha.msc2007 Mr or Mrs. 500 Points: 519 More actions · Answer 3

Thank you very much sir........

i got the result.....

Your's

Subha..........