테이블 정보 조회
DECLARE @TABLE_NAME nvarchar(100) SET @TABLE_NAME = 'Board' --테이블 컬럼 정보 SELECT ORDINAL_POSITION , COLUMN_NAME , ISNULL(( SELECT P.VALUE FROM :: FN_LISTEXTENDEDPROPERTY(NULL, 'SCHEMA', 'DBO', 'TABLE', TABLE_NAME, DEFAULT, DEFAULT)p), '') , DATA_TYPE , CHARACTER_MAXIMUM_LENGTH , IS_NULLABLE , COLUMN_DEFAULT , ISNULL(( SELECT VALUE FROM :: FN_LISTEXTENDEDPROPERTY(NULL, 'SCHEMA', 'DBO', 'TABLE', TAB..
2015. 7. 27.