Table의 모든 컬럼 보기

Select
 sys.sysusers.[name] As [TableOwner], --테이블 소유자  
 sys.sysobjects.[name] As [TableName], --테이블 명
 sys.syscolumns.[name] As [ColumnName], --컬럼 명
 sys.systypes.[name] As [DataType],  --데이터 타입
 sys.syscolumns.[length] As [Length], --길이
 sys.extended_properties.[value] As [ColumnDescription], --컬럼 Description
 sys.sysindexkeys.[indid] As [IsPrimaryKey]    --PrimaryKey
 
From sys.sysobjects
 Inner Join sys.syscolumns
  On sys.sysobjects.[id] = sys.syscolumns.[id]
 Inner Join sys.sysusers
  On sys.sysobjects.[uid] = sys.sysusers.[uid]
 Inner Join sys.systypes
  On sys.syscolumns.[xusertype] = sys.systypes.[xusertype]
 Left Outer Join sys.extended_properties
  On sys.syscolumns.[id] = sys.extended_properties.[major_id]
  And sys.syscolumns.[colid] = sys.extended_properties.[minor_id]
 Left Outer Join sys.sysindexkeys
  On sys.sysindexkeys.[colid] = sys.syscolumns.[colid]
  And sys.sysindexkeys.[id] = sys.syscolumns.[id]
Where sys.sysobjects.[xtype] = 'U'