MSSQL TIps

[ MSSQL 테이블 설명 쿼리 ] DECLARE @TABLE_NAME NVARCHAR(50) = '테이블명' SELECT A.NAME AS TABLE_NAME , C.VALUE AS TABLE_DESCRIPTION , D.NAME AS COLUMN_NAME , E.VALUE AS COLUMN_DESCRIPTION , F.DATA_TYPE AS TYPE , F.CHARACTER_OCTET_LENGTH AS LENGTH , F.IS_NULLABLE AS IS_NULLABLE , F.COLLATION_NAME AS COLLATION_NAME FROM SYSOBJECTS A WITH (NOLOCK) INNER JOIN SYSUSERS B WITH (NOLOCK) ON (A.UID = B.UID) INNER J..

2022.02.15