Sukru Alatas alatas
alatas
/ tablemeta.sql
Last active
April 27, 2022 21:55
— forked from asears/tablemeta.sql
Create markdown based on table metadata in SQL Server / SQL DW / Azure SQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH c1 | |
| AS (SELECT | |
| o.name AS tablename, | |
| c.colid, | |
| CONVERT(varchar(10), c.colid) + '|' + c.name + '|' + t.name + '|' + CONVERT(varchar(10), c.length) + '|' AS markdown | |
| FROM sysobjects o | |
| INNER JOIN syscolumns c | |
| ON c.id = o.id | |
| INNER JOIN systypes t | |
| ON t.xtype = c.xtype |