I want to kown if a field is an identity (counter) using a query or a stored procedure ?
ThanksReturns all identity columns in a database:select sysobjects.name as tablename,
syscolumns.name as IdentityColumnName
from sysobjects
inner join syscolumns on sysobjects.id = syscolumns.id
where syscolumns.autoval is not null
Showing posts with label kown. Show all posts
Showing posts with label kown. Show all posts
Subscribe to:
Posts (Atom)