34,590
社区成员
发帖
与我相关
我的任务
分享
Create table T(ID int primary key,ID2 int unique)
go
select xtype,type from sysobjects as a where parent_obj=OBJECT_ID('T')
/*
xtype type
PK K
UQ K
*/
select name from sys.objects where type='U'
select Name from sysobjects where xtype='U'
or
select * from sys.tables