TABLE 칼럼정보

해당 테이블 칼럼정보 보기

SELECT 

     a.name AS COLUMN_NAME,
     (
         SELECT name 
         FROM systypes 
         WHERE xtype = a.xtype 
         AND name<>'sysname'
     ) COLUMN_TYPE, 
     a.length AS COLUMN_LENGTH,
     (
         Case a.isnullable 
         When '0' Then 'N'
         Else 'Y'
         End
     ) AS NULL_YN
FROM syscolumns a, sysproperties b 
WHERE a.id*= b.id 
AND a.colid*= b.smallid 
AND a.id = (
    SELECT Id 
    FROM sysobjects 
    WHERE type='U' 

    AND Name ='테이블명'

);