select distinct name from syscharsets where name in(select default_character_set_name from INFORMATION_SCHEMA.SCHEMATA) result: cp936 cp=code page 代码页936 简体中文
1.sp_help db_name2.select default_character_set_name from INFORMATION_SCHEMA.SCHEMATA where catalog_name='db_name'
result:
cp936
cp=code page
代码页936 简体中文
where catalog_name='db_name'