sys.objects “type” abbreviations and their meanings – SQL Server

A system table or catalog table that stores “System Objects” is called sys.objects.

Every user-defined, schema-scoped object that is created in a database is represented by a row, including any natively built scalar user-defined functions.

The columns such as “type” has abbreviated information about the type of the object. Their meaning has been given below.

C = CHECK constraint
D = DEFAULT (constraint or stand-alone)
F = FOREIGN KEY constraint
PK = PRIMARY KEY constraint
R = Rule (old-style, stand-alone)
TA = Assembly (CLR-integration) trigger
TR = SQL trigger
UQ = UNIQUE constraint
EC = Edge constraint
AF = Aggregate function (CLR)
FN = SQL scalar function
FS = Assembly (CLR) scalar-function
FT = Assembly (CLR) table-valued function
IF = SQL inline table-valued function
IT = Internal table
P = SQL Stored Procedure
PC = Assembly (CLR) stored-procedure
PG = Plan guide
RF = Replication-filter-procedure
S = System base table
SN = Synonym
SO = Sequence object
U = Table (user-defined)
V = View
SQ = Service queue
TF = SQL table-valued-function
TT = Table type
UQ = UNIQUE constraint
X = Extended stored procedure

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s