SQL 2005 collation

Question

Post reply

SQL 2005 collation

alan.nichol

SSC-Addicted

Points: 409
More actions
April 16, 2010 at 4:05 am

#139677

Dear ServerCentral
Is there a simple scripting way that I can see the collation set against each table in a database.
I am getting some conflict in that the collation set for the database is not the same for each table. So rather than open up each table I was wondering if there is a script I could use to display this collation for each table.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Pulivarthi Sasidhar SSCertifiable Points: 6706 More actions · Answer 1

hi,

Look into the following links....The column collation list existed .....but not table...

http://www.databasejournal.com/features/mssql/article.php/10894_3302341_1/SQL-Server-and-Collation.htm

http://blog.sqlauthority.com/2008/12/16/sql-server-find-collation-of-database-and-table-column-using-t-sql/

Sasidhar Chowdary

Lowell SSC Guru Points: 323546 More actions · Answer 2

there is a default collation at the database level, which you can see in sys.databases.

collation is not at the table level, but for each individual column. the value is visible in sys.columns.

select

object_name(object_id) As TableName,

name As ColumnName,

collation_name,

column_id

from sys.columns

Order By

object_name(object_id),

column_id

alan.nichol (4/16/2010)
Dear ServerCentral
Is there a simple scripting way that I can see the collation set against each table in a database.
I am getting some conflict in that the collation set for the database is not the same for each table. So rather than open up each table I was wondering if there is a script I could use to display this collation for each table.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!