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
반응형