MSSQL Sysobjects Types

select * from sys.sysobjects

select * from sys.objects

quick copy-paste for: where type in() :

function: 'AF', 'FN', 'FS', 'FT', 'IF', 'TF'
SP: 'P', 'PC', 'RF', 'X'
view: 'V'
table: 'S', 'U'
synonym: 'SN'
constraint (& keys, etc...): 'C', 'D', 'F', 'PK', 'UQ'
trigger: 'TA', 'TR'
roles: 'R'
other: 'PG', 'SQ'