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
Big Data and SQL 