Check functionality with non usual tables

[drumsta]

Table: sys.objects
Column name: type

• IT = Internal table
• S = System base table
• IF = SQL inline table-valued function
• TF = SQL table-valued-function
• FT = Assembly (CLR) table-valued function

SELECT type, type_desc, object_id, name
FROM master.sys.all_objects
WHERE type IN ('IT', 'S', 'IF', 'TF', 'FT')
ORDER BY type, name