摘要：SQL Server 2000数据库字典—表结构.sql SELECT TOP 100 PERCENT --a.id, CASE WHEN a.colorder = 1 THEN d.name ELSE '' END AS 表名, CASE WHEN a.colorder = 1 THEN isnull(f.value, '') ELSE '' END AS 表说明, a.colorder AS ... 阅读全文

摘要：--在表格中输入每个表的描述 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_ColumnMap]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[T_ColumnMap] GO CREATE TABLE [dbo].[T_... 阅读全文