DataBase/SQL Server
테이블 리스트
탑~!
2016. 2. 22. 17:31
SELECT NAME AS TABLE_NAME
, (SELECT VALUE FROM SYS.EXTENDED_PROPERTIES WHERE MAJOR_ID = A.ID AND MINOR_ID = 0 ) TABLE_COMMENT
FROM SYSOBJECTS A
WHERE RTRIM(A.XTYPE) = 'U'
ORDER BY NAME
728x90
반응형