List of MS SQL Server object types:
- C – CHECK_CONSTRAINT
- D – DEFAULT_CONSTRAINT
- F – FOREIGN_KEY_CONSTRAINT
- FN- SQL_SCALAR_FUNCTION
- IF – SQL_INLINE_TABLE_VALUED_FUNCTION
- IT – INTERNAL_TABLE
- P – SQL_STORED_PROCEDURE
- PK – PRIMARY_KEY_CONSTRAINT
- S – SYSTEM_TABLE
- SQ – SERVICE_QUEUE
- TR – SQL_TRIGGER
- U – USER_TABLE
- UQ – UNIQUE_CONSTRAINT
- V – VIEW
This can be obtained with simple query:
select distinct type, type_desc from sys.objects order by 1