how do we get the collation of objects in t-sql

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

how do we get the collation of objects in t-sql

Author

Topic

rtutus
Aged Yak Warrior

522 Posts

Posted - 2007-01-09 : 21:33:38

Hi can i get the collation of these objects in t-sql pls?

- syscomments.text
- a column in a user table in a database
- an instance collation

- and finally the collation of a table

Thank you

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-09 : 21:38:12

[code]
select SERVERPROPERTY('COLLATION')

sp_help table_name
[/code]

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-09 : 21:40:09

And also


select name, collation from syscolumns where id = object_id('table_name') and name = 'column_name'

rtutus
Aged Yak Warrior

522 Posts

Posted - 2007-01-09 : 21:53:39

so cool
any idea how we can change the collations of each of those objects: instance, column, table and database
Thanks a lot

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-09 : 22:36:52

refer to collation thread in the FAQ
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46915

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources