CREATE VIEW dbo.SystemObjectTypes
AS
SELECT [Type],
[TypeName],
[CreateDefinition],
[CreateOrder]
FROM ( VALUES ( 'AF', 'Aggregate function (CLR)', 'AGGREGATE', NULL), ( 'FS', 'Assembly (CLR) scalar-function', 'FUNCTION', NULL),
( 'FT', 'Assembly (CLR) table-valued function', 'FUNCTION', NULL), ( 'PG', 'Plan guide', 'PLAN GUIDE', NULL),
( 'PC', 'Assembly (CLR) stored-procedure', 'PROCEDURE', NULL), ( 'RF', 'Replication-filter-procedure', 'PROCEDURE', NULL),
( 'X', 'Extended stored procedure', 'PROCEDURE', NULL), ( 'SQ', 'Service queue', 'QUEUE', NULL), ( 'R', 'Rule (old-style, stand-alone)', 'RULE', NULL),
( 'IT', 'Internal table', 'TABLE', NULL), ( 'S', 'System base table', 'TABLE', NULL), ( 'TA', 'Assembly (CLR) DML trigger', 'TRIGGER', NULL),
( 'U', 'Table', 'TABLE', 1), ( 'PK', 'PRIMARY KEY constraint', 'PRIMARY KEY', 2), ( 'D', 'DEFAULT (constraint or stand-alone)', 'DEFAULT', 3),
( 'UQ', 'UNIQUE constraint', 'UNIQUE CONSTRAINT', 4), ( 'C', 'CHECK constraint', 'CHECK', 5), ( 'F', 'FOREIGN KEY constraint', 'FOREIGN KEY', 10),
( 'TR', 'SQL DML trigger', 'TRIGGER', 13), ( 'TT', 'Table type', 'TYPE', 14), ( 'SN', 'Synonym', 'SYNONYM', 11), ( 'V', 'View', 'VIEW', 15),
( 'FN', 'SQL scalar function', 'FUNCTION', 16), ( 'IF', 'SQL inline table-valued function', 'FUNCTION', 17),
( 'TF', 'Table Valued Function', 'FUNCTION', 18), ( 'P', 'Stored procedure', 'PROCEDURE', 20) ) AS so ([Type], [TypeName], [CreateDefinition], [CreateOrder])