摘要: SELECT A.name AS table_name, B.name AS column_name, C.value AS column_description FROM sys.tables A INNER JOIN sys.columns B ON B.object_id = A.object 阅读全文
posted @ 2021-09-13 12:07 薄心之心 阅读(227) 评论(0) 推荐(0) 编辑
摘要: 1 select ROW_NUMBER() OVER (ORDER BY a.name) AS 序号, 2 a.name AS 表名, 3 CONVERT(NVARCHAR(100),isnull(g.[value],'-')) AS 说明 4 from 5 sys.tables a left jo 阅读全文
posted @ 2021-09-13 12:03 薄心之心 阅读(340) 评论(0) 推荐(0) 编辑