Tested on server version: SQL Server 2016 Developer Edition Reference info accurate on: January, 2018 was wanting to make THIS stored procedure:
Tag: sys.schemas
Return all System Object Definitions (DDL)
Tested on server version: SQL Server 2016 Developer Edition Reference info accurate on: January, 2018 The following view returns a comprehensive list of all System Objects on a server. It returns the object name, with and without concatinating the schema to the name. The view can be created and executed as-is.