테이블 칼럼 조회
SELECTA.TABLE_NAME,C.VALUE AS TABLE_COMMENT,A.COLUMN_NAME, A.DATA_TYPE,ISNULL(CAST(A.CHARACTER_MAXIMUM_LENGTH AS VARCHAR) ,CAST(A.NUMERIC_PRECISION AS VARCHAR) + ',' + CAST(A.NUMERIC_SCALE AS VARCHAR)) AS COLUMN_LENGTH,A.COLUMN_DEFAULT,CASE WHEN A.IS_NULLABLE = 'YES' THEN '' ELSE 'Not Null' END,'PK'= CASE WHEN OBJECTPROPERTY(OBJECT_ID(D.CONSTRAINT_NAME), 'ISPRIMARYKEY') = 1 THEN 'Y' ELSE '' END,..
DataBase/SQL Server
2016. 8. 1. 15:56