hx_ShowIdentityColumns

DROP PROCEDURE hx_ShowIdentityColumns
go
/* Robert Vallee 01/11/2001
rvallee@hybridx.com
input:None
output:Table format
Desc:List out all columns that are set as Identity columns in the database.
Warnings: None.
*/
CREATE PROCEDURE hx_ShowIdentityColumns AS

select o.name as Table_Name, c.name as [Column_Name] 
from syscolumns c, sysobjects o
where c.id=o.id and (c.status & 128)=128
order by o.name,c.name