Catalog Views
Catalog Views Catalog views contains info for metadata for each user table. Catalog views belong to the sys schema, so you have to use the schema name when you access one of the objects. This section describes some of the most important catalog views. Applies to : SQL Server, Azure SQL Database, Azure Synapse Analytics Views sys.schemas Contains info for each database schema. Columns: name: Name of the schema. Unique within the database schema_id(int): ID number of the schema. Unique within the database sys.tables Contains info for each user-table in SQL server. Columns: name: Table Name object_id(int): Object id number. Is a unique number for each table in the database. schema_id(int): ID number to identify which schema the table belongs. sys.columns Contains info for each column of a table. Columns: object_id(int): ID number to identify which table this column belongs. system_type_id(tinyint): ID of the system type of the c...