sql server的sysobjects表中xtype字段值的含义

时间:2024-01-16 16:49:44
xtype字段包含的值的意思如下:
AF = Aggregate function (CLR) 聚合函数(CLR) 
C = CHECK constraint CHECK约束 
D = Default or DEFAULT constraint 默认或DEFAULT约束 
F = FOREIGN KEY constraint 外键约束 
L = Log 日志 
FN = Scalar function 标量函数 
FS = Assembly (CLR) scalar-function 组装(CLR)标量函数 
FT = Assembly (CLR) table-valued function 程序集(CLR)表值函数 
IF = In-lined table-function 内嵌表函数 
IT = Internal table 内部表 
P = Stored procedure 存储过程 
PC = Assembly (CLR) stored-procedure 组装(CLR)存储过程 
PK = PRIMARY KEY constraint (type is K) 主键约束(类型是K) 
RF = Replication filter stored procedure 制筛选存储过程 
S = System table 系统表 
SN = Synonym 同义词 
SQ = Service queue 服务序列 
TA = Assembly (CLR) DML trigger 装配(CLR) DML触发器 
TF = Table function 表函数 
TR = SQL DML Trigger 触发器 
TT = Table type 
U = User table用户表 
UQ = UNIQUE constraint (type is K) 唯一约束(类型是K) 
V = View 视图 
X = Extended stored procedure 扩展存储过程