SQL Server Metadata Queries Using View Catalog

I need to query SQL Server Metadata information from system view catalog (using [login to view URL], etc. ). Not from information schema. Queries needed needed: - all databases (name, only) For each database I need the following queries: - get all tables - get all views - get all functions - get all stored procedures - get all users (details, roles, etc) - get all information about database (file names and locations, size, etc) For each table in each database I need the following queries - schemas - all columns with details (PK, FK, type, size, default value, etc) - all constraints and their details - all triggers and their details - all indexes and their details