获取sql2005表结构

获取sql2005表结构  

SELECT  sps. object_id   As  ProcedureId,sps.name  As  ProcedureName,Sss.name  As  SchemaName,( case   when  ( SELECT   COUNT ( * )  FROM  sys.sysdepends  WHERE  id = sps. object_id   and  resultobj = 1 ) = 0   then   0   else   1   end )  As  IsNeedOpenDb
FROM  sys.procedures sps  INNER   JOIN  sys.schemas Sss  on  Sss.schema_id = Sps.schema_id

 

SELECT  ST. object_id   As  TableId,SS.name  As  SchemaName,ST.name  As  TableName,Sep.value  As  TableDescription  FROM  sys.tables ST  LEFT   OUTER   JOIN  sys.schemas SS  ON  SS.schema_id = ST.schema_id  LEFT   OUTER   JOIN  sys.extended_properties Sep  On  Sep.major_id = ST. object_id   and  minor_id = 0

SELECT  
SC.Colorder  As  ColumnId , SC.Name  As  ColumnName,Sep.value  As  ColumnDescription, St.Name  As  TypeName, SC.Prec,SC.Scale,SC.Colstat,Sac.Is_Identity,SC.Iscomputed, SC.Isnullable, SC.Colorder,Sic.index_id  As  KeyIndex,Scs. text   As  DefaultValue,Scss. text   As  AutoValue 

FROM  sys.syscolumns  AS  SC 

LEFT   OUTER   JOIN  sys.systypes St  ON  (St.xtype = SC.xtype)  AND  (St.xUSERtype = SC.xtype) 

LEFT   OUTER   JOIN  sys.syscomments Scs  On  Scs.Id = SC.cdefault 
LEFT   OUTER   JOIN  sys.syscomments Scss  On  Scss.Id = SC.id  and  Scss. number = SC.colorder 

LEFT   OUTER   JOIN  sys.all_columns Sac  On  Sac. object_id = Sc.id  and  Sac.column_id = SC.Colorder 

LEFT   OUTER   JOIN  sys.extended_properties Sep  On  Sep.major_id = Sc.id  and  Sep.minor_id = SC.Colorder

LEFT   OUTER   JOIN  sys.index_columns Sic  On  Sic. object_id = Sc.id  and  Sic.column_id = SC.Colorder 

WHERE  (SC.id  =  表ID)