메모장

HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Terminal Server \ Wds \ rdpwd \Tds \ tcp

HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Terminal Server \ WWinStation \ RDP \ tcp

10진코드로 수정(방화벽 인바운드 예외추가한 포트)

/**********************************************

 테이블의 컬럼정보 보기

**********************************************/

declare @tb_name nvarchar(30)
declare @tb_Id    int

/******** Input Table Name ********/
set @tb_name = ''

select @tb_id = id
  from sysobjects
  where name = @tb_name

select a.colid as NO
    , a.name      as ColumnName
    , b.name      as DataType
    , CASE WHEN b.name IN ('numeric', 'decimal') --18.5 형태의 표현
      THEN convert(varchar(100),a.xprec) + '.' + convert(varchar(100),a.xscale)
     WHEN b.name IN ('int','smallint')   --해당열 empty space
      THEN ''  
     ELSE convert(varchar(100),a.length) END      as DataLength   
    , CASE a.isnullable WHEN 0 THEN 'NOT NULL'
             WHEN 1 THEN 'NULL' END   as NullValue
    , c.value       as Description
from syscolumns a
  inner join systypes b
  on a.xusertype = b.xusertype
  left outer join SYS.EXTENDED_PROPERTIES c
  on a.id = c.major_id and a.colid = c.minor_id
  where a.id = @tb_id
order by a.colid

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'