sqlserver system object type

select distinct s.type, s.type_desc from sys.objects as s inner join
(select distinct type from sys.objects) as t on s.type = t.type

result:

type	type_desc
FN	SQL_SCALAR_FUNCTION
UQ	UNIQUE_CONSTRAINT
SQ	SERVICE_QUEUE
U	USER_TABLE
D	DEFAULT_CONSTRAINT
PK	PRIMARY_KEY_CONSTRAINT
V	VIEW
S	SYSTEM_TABLE
IT	INTERNAL_TABLE
P	SQL_STORED_PROCEDURE
TF	SQL_TABLE_VALUED_FUNCTION
TR	SQL_TRIGGER