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 |
Last active
July 17, 2018 14:14
-
-
Save marcelodeandrade/976becf753c5c741afdc7d5d97cc2980 to your computer and use it in GitHub Desktop.
SQL SERVER object types
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment