ITPub博客

显示数据库中表的主键[@more@]以下以sqlserver为例写的显示数据库中表的主键declare @objname nvarchar(50),@i int, @thiskey nvarchar(131),@keys nvarchar(2126),@indid int,@objid int CREATE TABLE #pktab ( table_name nvarchar(50), pk_name nvarchar(300) ) declare ms_crs_ind cursor local static for select a.name from sysobjects a where xtype='U' and name like 'T%' order by name open ms_crs_ind fetch ms_crs_ind into @objname while @@fetch_status >= 0 begin set @objid=object_id(@