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.
| Author |
Topic |
|
OldMySQLUser
Constraint Violating Yak Guru
301 Posts |
 Posted - 2009-02-09 : 05:51:43
|
| How can I check the tables in a database to see those whos collation type does not match the current default please? |
|
|
Jai Krishna
Constraint Violating Yak Guru
333 Posts |
Posted - 2009-02-09 : 06:00:42
|
| select distinct table_name from information_schema.columns where collation_name <> ur current default collationJai Krishna |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-09 : 06:14:33
|
| select distinct table_name from information_schema.columns where COLLATION_NAME <> DATABASEPROPERTYEX('your database name here','COLLATION') |
|
|
|
|
|
|
Table collation check