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