Field정보 알아내기 쿼리

SELECT B.name, C.name, B.length

FROM SYSOBJECTS as A

     inner join SYSCOLUMNS as B on

           A.ID = B.ID

     inner join systypes as C on

           B.xtype = C.xtype

WHERE A.XTYPE ='U'

     AND A.NAME = '테이블명'