摘要:
SELECT TOP(100) PERCENT --a.id, d.name AS 表名, CASE WHEN a.colorder = 1 THEN ISNULL(f.value, '') ELSE '' END AS 表说明, ISNULL(g.value, '') AS 字段说明, a.name AS 字段名, b.name AS 类型 ,case when lower( b.name) = 'timestamp' then ... 阅读全文
摘要:
SELECT TOP(100) PERCENT --a.id, d.name AS 表名, CASE WHEN a.colorder = 1 THEN ISNULL(f.value, '') ELSE '' END AS 表说明, ISNULL(g.value, '') AS 字段说明, a.name AS 字段名, b.name AS 类型 ,case when lower( b.name) = 'timestamp' then ... 阅读全文
摘要:
SELECT name AS column_name,TYPE_NAME(system_type_id) AS column_type, max_length,is_nullable FROM sys.columns WHERE object_id=OBJECT_ID(N'表名') 阅读全文
|