RecorteX

Buscar si una tabla tiene campo identity, y saber cual es

descargar
 
dim @tabla  AS varchar(20)
SELECT @tabla='tablaabuscar'
SELECT o.name , c.name 
FROM syscolumns c, sysobjects o
WHERE c.STATUS & 128 = 128
AND o.id = c.id
AND o.name=@tabla
ORDER BY o.name