sqlserver.md

-- tables
SELECT * FROM INFORMATION_SCHEMA.TABLES;

-- columns
SELECT * FROM INFORMATION_SCHEMA.COLUMNS;