簡單的3個sql視圖搞定所有sqlserver數(shù)據(jù)庫字典(轉(zhuǎn)載）-文庫吧
2025-08-01 08:57 本頁面
【正文】 HEN 39?！?9。 ELSE 39。39。 END AS 允許空 , ISNULL(, 39。39。) AS 默認(rèn)值 , ISNULL(g.[value], 39。39。) AS 字段說明 , AS 創(chuàng)建時間 , CASE WHEN = 1 THEN ELSE NULL END AS 更改時間 FROM a LEFT OUTER JOIN b ON = INNER JOIN d ON = AND = 39。U39。 AND = 0 LEFT OUTER JOIN e ON = LEFT OUTER JOIN g ON = AND = AND = 39。MS_Description39。 LEFT OUTER JOIN f ON = AND = 0 AND = 39。MS_Description39。 ORDER BY , SqlServer2020數(shù)據(jù)庫字典 表結(jié)構(gòu) .sql SELECT TOP 100 PERCENT , CASE WHEN = 1 THEN ELSE 39。39。 END AS 表名 , CASE WHEN = 1 THEN isnull(, 39。39。) ELSE 39。39。 END AS 表說明 , AS 字段序號 , AS 字段名 , CASE WHEN COLUMNPROPERTY(, , 39。IsIdentity39。) = 1 THEN 39?！?9。 ELSE 39。39。 END AS 標(biāo)識 , CASE WHEN EXISTS (SELECT 1 FROM si INNER JOIN sik ON = AND = INNER JOIN sc ON = AND = INNER JOIN so ON = AND =
公司管理相關(guān)推薦
鄂ICP備17016276號-1