查看Table Schema
CREATE PROCEDURE View_Table_ColData
@Table_Name varchar(30)
AS
Select c.name as 'Col_Name',d.name as 'Data_Type',c.length as 'Data_Length',c.xprec,c.xscale,e.text as 'DefualtValue',b.value as 'Description',c.colstat as 'KeyValue',a.crdate as 'CreateDate'
From sysobjects as a full join syscolumns as c on a.id=c.id
Full join systypes as d on c.xtype=d.xtype and c.xusertype=d.xusertype
Full join sysproperties as b on a.id=b.id and c.colid=b.smallid
Full outer join syscomments as e on c.cdefault=e.id
Where a.name=@Table_Name
Order by c.colid
GO
@Table_Name varchar(30)
AS
Select c.name as 'Col_Name',d.name as 'Data_Type',c.length as 'Data_Length',c.xprec,c.xscale,e.text as 'DefualtValue',b.value as 'Description',c.colstat as 'KeyValue',a.crdate as 'CreateDate'
From sysobjects as a full join syscolumns as c on a.id=c.id
Full join systypes as d on c.xtype=d.xtype and c.xusertype=d.xusertype
Full join sysproperties as b on a.id=b.id and c.colid=b.smallid
Full outer join syscomments as e on c.cdefault=e.id
Where a.name=@Table_Name
Order by c.colid
GO