如何获取数据库中特定表的排序规则？ [英] How I can obtain the collation of a specific table in a database?

问题描述

如何获取数据库中特定表的排序规则？

How I can obtain the collation of a specific table in a database? Is it possible that a table have different collation in db?

推荐答案

表级别的排序规则是基于每列的，因此，表中的数据库排序规则是否可能不同？排序规则可能不同于数据库。如果没有在列级别定义排序规则，则默认为数据库排序规则设置。

Collation at the table level is on a per column basis, so it is possible to have a collation different than the database. If the collation is not defined at the column level, it defaults to the database collation setting.

SQL Server 2000：

SQL Server 2000:

SELECT c.name, 
       c.collation 
  FROM SYSCOLUMNS c
 WHERE [id] = OBJECT_ID('your_table_name')

SQL Server 2005 +：

SQL Server 2005+:

SELECT c.name, 
       c.collation_name
  FROM SYS.COLUMNS c
  JOIN SYS.TABLES t ON t.object_id = c.object_id
 WHERE t.name = 'your_table_name'

这篇关于如何获取数据库中特定表的排序规则？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！