Skip to content

Instantly share code, notes, and snippets.

@marcelodeandrade
Last active July 17, 2018 14:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marcelodeandrade/976becf753c5c741afdc7d5d97cc2980 to your computer and use it in GitHub Desktop.
Save marcelodeandrade/976becf753c5c741afdc7d5d97cc2980 to your computer and use it in GitHub Desktop.
SQL SERVER object types
type type_desc
AF Aggregate function (CLR)
C CHECK constraint
D Default or DEFAULT constraint
F FOREIGN KEY constraint
FN Scalar function
FS Assembly (CLR) scalar-function
FT Assembly (CLR) table-valued function
IF In-lined table-function
IT Internal table
K PRIMARY KEY or UNIQUE constraint
L Log
P Stored procedure
PC Assembly (CLR) stored-procedure
R Rule
RF Replication filter stored procedure
S System table
SN Synonym
SQ Service queue
TA Assembly (CLR) DML trigger
TF Table function
TR SQL DML Trigger
TT Table type
U User table
V View
X Extended stored procedure
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment