Identity field with a query ?

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