Obten un reporte de las tablas que contienen una llave primaria en tu base de datos.
create table #pk (TABLE_QUALIFIER varchar(50),TABLE_OWNER varchar(50),TABLE_NAME varchar(50),COLUMN_NAME varchar(50),KEY_SEQ smallint, PK_NAME varchar(50))
declare
@table varchar(50),
@str varchar(128)
declare tablecurs cursor for
select name from sysobjects where type = 'U'
open tablecurs
fetch tablecurs into @table
WHILE @@FETCH_STATUS = 0
Begin
Select @str = 'exec sp_pkeys '+ @table
insert into #pk
exec(@str)
--print @str
fetch tablecurs into @table
end
deallocate tablecurs
go
select * from #pk
select a.name as Tabla , b.PK_NAME as Llave from sysobjects as a left outer join #pk as b ON a.name = b.TABLE_NAME
order by a.name