helptable1 [MSSQL] TABLE 정보 쉽게 확인하기 [특정 테이블 정보 쉽게 확인 Query] set ANSI_NULLS ONset QUOTED_IDENTIFIER ON create PROC [dbo].[SP_HELPTABLE] ( @P_TABNAME VARCHAR(100)) AS SELECT TB.NAME, CAST(q.[VALUE] AS VARCHAR(1000)) AS TAB_CMT FROM SYS.OBJECTS TB LEFT OUTER JOIN SYS.EXTENDED_PROPERTIES q ON q.MAJOR_ID = tb.OBJECT_ID AND q.MINOR_ID = 0 AND q.CLASS = 1 AND q.NAME = 'MS_Description' WHERE TB.NAME = LTRIM(RTRIM(@P_TABNAME)) SELECT clmns.. 2018. 11. 5. 이전 1 다음