Article From:https://www.cnblogs.com/holab/p/9970230.html
xtypeThe field contains the following values:
AF = Aggregate function (CLR) Aggregate function (CLR)
C = CHECK constraint CHECKConstraint
D = Default or DEFAULT constraint Default or DEFAULT constraints
F = FOREIGN KEY constraint Foreign key constraint
L = Log Journal
FN = Scalar function Scalar function
FS = Assembly (CLR) scalar-function Assembly (CLR) scalar function
FT = Assembly (CLR) table-valued function Assembly (CLR) table-valued functions
IF = In-lined table-function Embedded table function
IT = Internal table Internal table
P = Stored procedure Stored procedure
PC = Assembly (CLR) stored-procedure Assembly (CLR) stored procedures
PK = PRIMARY KEY constraint (type is K) Primary key constraints (type K)
RF = Replication filter stored procedure System Screening Stored Procedures
S = System table System table
SN = Synonym Synonyms
SQ = Service queue Service sequence
TA = Assembly (CLR) DML trigger Assembly (CLR) DML flip-flop
TF = Table function Table function
TR = SQL DML Trigger Trigger
TT = Table type 
U = User tableUser table
UQ = UNIQUE constraint (type is K) Unique constraint (type K)
V = View View
X = Extended stored procedure Extended stored procedure
 
Original: https://blog.csdn.net/jackmacro/article/details/6405871

Leave a Reply

Your email address will not be published. Required fields are marked *