mssql 쿼리명세서 생성
프로젝트 마무리때 주로 쓰게된다. SELECT A.Table_Name, C.Value Table_Description, 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) ) Column_Length, A.Column_Default, CASE WHEN A.Is_Nullable = 'YES' THEN 'Y' ELSE 'N' END Is_Nullable, B.value Colum_Description FROM INFORMATION_SCHEMA.ColumnS A LEFT JOIN ..
프로그래밍/DB
2020. 11. 16. 15:59