mssql테이블설명1 MSSQL 테이블, 컬럼 설명(Description) 함께 조회 하기 ■ 테이블 및 컬럼 설명 함께 조회하기 쿼리입니다. SELECT A.NAME AS TableName , (SELECT VALUE FROM SYS.EXTENDED_PROPERTIES WHERE MAJOR_ID = A.ID AND MINOR_ID = 0 AND name = 'User_Description') AS User_Description , (SELECT VALUE FROM SYS.EXTENDED_PROPERTIES WHERE MAJOR_ID = A.ID AND MINOR_ID = 0 AND name = 'MS_Description') AS MS_Description , (SELECT TOP 1 VALUE FROM SYS.EXTENDED_PROPERTIES WHERE MAJOR_ID = A.ID AND.. 2019. 7. 6. 이전 1 다음