怎么查sqlserver 2008中某个数据库的编码方式

SELECT

COLLATIONPROPERTY('Chinese_PRC_Stroke_CI_AI_KS_WS',

'CodePage')

下面是查询结果：

936

简体中文GBK

950

繁体中文BIG5

437

美国/加拿大英语

932

日文

949

韩文

866

俄文

65001

unicode

UFT-8

这个也是从 oid2name 中扒出来的：

[postgres@localhost bin]$ ./oid2name -d postgres

From database "postgres":

now:

SELECT pg_catalog.pg_relation_filenode(c.oid) as "Filenode", relname as "Table Name" FROM pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_catalog.pg_database d ON d.datname = pg_catalog.current_database(),pg_catalog.pg_tablespace t WHERE relkind IN ('r') AND n.nspname NOT IN ('pg_catalog', 'information_schema') AND n.nspname !~ '^pg_toast' AND t.oid = CASE WHEN reltablespace <>0 THEN reltablespace ELSE dattablespace END ORDER BY relname

Filenode Table Name

---