Check functionality with non usual tables

[drumsta]

Table: sys.objects Column name: type

• [ ] IT = Internal table
• [ ] S = System base table
• [x] IF = SQL inline table-valued function
• [x] 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