곰탱이의 개인블로그

SELECT TABLE_NAME,  COLUMN_NAME, DATA_TYPE,
      CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE, COLUMN_DEFAULT
      FROM INFORMATION_SCHEMA.COLUMNS
   WHERE DATA_TYPE LIKE '%char'  and DATA_TYPE not in ('nvarchar' , 'nchar')
    --group by TABLE_NAME
      ORDER BY TABLE_NAME