簡單的3個sql視圖搞定所有sqlserver數(shù)據(jù)庫字典(轉(zhuǎn)載-文庫吧資料
2024-09-12 08:57本頁面
【正文】 據(jù)庫字典 表結(jié)構(gòu) .sql SELECT TOP 100 PERCENT , CASE WHEN = 1 THEN ELSE 39。 END AS 表名 , CASE WHEN = 1 THEN isnull(, 39。) ELSE 39。 END AS 表說明 , AS 字段序號 , AS 字段名 , CASE WHEN COLUMNPROPERTY(, , 39。) = 1 THEN 39。 ELSE 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 = 39。 WHERE = AND = ) THEN 39。 ELSE 39。 END AS 主鍵 , AS 類型 , AS 長度 , COLUMNPROPERTY(, , 39。) AS 精度 , ISNULL(COLUMNPROPERTY(, , 39。), 0) AS 小數(shù)位數(shù) , CASE WHEN = 1 THEN 39。 ELSE 39。 END AS 允許空 , ISNULL(, 39。) AS 默認值 , ISNULL(g.[value], 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。 AND = 0 LEFT OUTER JOIN e ON = LEFT OUTER JOIN g ON = AND
公司管理相關(guān)推薦
鄂ICP備17016276號-1