MSSQL 테이블 COMMENT 보기

-- 테이블 정보 보기

SELECT * FROM sysobjects WHERE xtype='U';

SELECT * FROM  INFORMATION_SCHEMA.TABLES;

SELECT * FROM ::FN_LISTEXTENDEDPROPERTY(NULL, 'User','dbo','table', null, NULL, NULL) order by objname

SELECT * FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', '[테이블명]', 'column', default)