Community

sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)

(Kenneth Fisher) If you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into a schemaname and objectname and vise versa.