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

	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