查询表的所有字段及类型

     SELECT name=COLUMN_NAME,type=CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NOT NULL
     THEN DATA_TYPE+'('+CONVERT(VARCHAR(10),CHARACTER_MAXIMUM_LENGTH)+')'
     ELSE DATA_TYPE END,col='',temp=''
     FROM information_schema.COLUMNS WHERE TABLE_NAME = 'table_name'