sqlserver采集字段的sql语句

SELECT CAST
    ( o.name AS VARCHAR ( 1000 ) ) AS TABLE_NAME,
    CAST ( c.name AS VARCHAR ( 100 ) ) AS COLUMN_NAME,
    c.column_id AS ORDINAL_POSITION,
    c.PRECISION AS DECIMAL_PRECISION,
    c.SCALE AS NUMERIC_SCALE,
    SCHEMA_NAME( o.schema_id ) AS TABLE_SCHEMA,
    c.system_type_id AS SQL_DATA_TYPE,
    c.user_type_id    ,
    CAST ( TYPE_NAME( c.user_type_id ) AS VARCHAR ( 100 ) ) AS DATA_TYPE,
    case when c.IS_NULLABLE=0 then 'No' else 'Yes' end as IS_NULLABLE ,
CASE
            WHEN ( c.user_type_id>= 40 AND c.user_type_id= 40 AND c.user_type_id= 40 AND c.user_type_id= 40 AND c.user_type_id