Exploring SQL Server table metadata with SSMS and TSQL

Exploring SQL Server table metadata with SSMS and TSQL Good LINK on Playing with SQL SERVER METADATA TABLES
https://www.simple-talk.com/sql/t-sql-programming/exploring-sql-server-table-metadata-with-ssms-and-tsql/