--資料庫表名及欄位名都無數據字典，現在補充上。 --暫時想到如下笨辦法： --思路，分兩步，一是填寫表的字典。二是填寫表中欄位的字典。 --將表名導出到Table_Description --將列名導出到Column_Description --然後填寫上Description，最後調用存儲過程， ...
--資料庫表名及欄位名都無數據字典，現在補充上。 --暫時想到如下笨辦法： --思路，分兩步，一是填寫表的字典。二是填寫表中欄位的字典。 --將表名導出到Table_Description --將列名導出到Column_Description --然後填寫上Description，最後調用存儲過程，分別更新或添加字典到表和欄位上。 --最後，利用三視圖，顯示數據字典：表結構，索引，全部用戶對象。表結果是重點。 --也可以用動軟生成Word或Html形式。 一、開始：導出表信息到Table_Description表 創建Table_Description表 create table Table_Description (TableName nvarchar(50),Descriptions nvarchar(255),RowCounts int,IsUsed bit) 載入用戶表到Table_Description表 insert into Table_Description (TableName) select name from sys.tables a where name not in ('sysdiagrams','Table_Description','Column_Description') and not exists (select 1 from Table_Description where TableName=a.name) order by name 統計表記錄行總數代碼示例： select schema_name(t.schema_id) as [Schema], t.name as TableName,i.rows as [RowCount] from sys.tables as t, sysindexes as i where t.object_id = i.id and i.indid <=1 更新表記錄行總數 update a set rowcounts=b.[rowcount] from Table_Description a, (select schema_name(t.schema_id) as [Schema], t.name as TableName,i.rows as [RowCount] from sys.tables as t, sysindexes as i where t.object_id = i.id and i.indid <=1) b where a.TableName=b.TableName 單獨填寫各表的字典 update Table_Description set Descriptions='客戶資料表.主檔',isused=1 where TableName='KFZL' 刪除無用資料字典表 delete from Table_Description where isnull(IsUsed,0)=0 到此字典表Table_Description填寫完畢，結果如下圖：
二、載入字典表的全部列到Column_Description表
載入字典表的全部列
create table Column_Description
(TableName nvarchar(50),ColumnName nvarchar(50),Descriptions nvarchar(255),IsUsed bit)
insert into Column_Description (TableName,ColumnName)
select b.TableName,a.name from sys.all_columns a,Table_Description b
where a.object_id = object_id(b.TableName) and b.IsUsed=1
and not exists (select 1 from Column_Description c where b.TableName=c.TableName and a.name=c.ColumnName)
order by b.TableName,a.column_id
導出Column_Description到Excel進行字典填寫，填寫完後，回傳到Column_Description表中。效果圖如下：
總結：
整體來說，自己第一次動手還算滿意！
