|
Home > Archive > MS SQL Server > October 2006 > Table Collation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Cenk FIRAT 2006-10-24, 6:37 pm |
| Hi,
I have tables (it has data) and i want to change table collation (not column
collation)
is it possible? if possible how i can change table collation?
Thanks,
Cenk FIRAT
| |
|
| You cannot change the collation at table level.
Its either the database or the column.
"Cenk FIRAT" <Cenk FIRAT@discussions.microsoft.com> wrote in message
news:E0070291-5B6D-47D6-A8D8- 1643BE1482B6@microso
ft.com...
> Hi,
> I have tables (it has data) and i want to change table collation (not
> column
> collation)
> is it possible? if possible how i can change table collation?
>
> Thanks,
> Cenk FIRAT
| |
| Tibor Karaszi 2006-10-24, 6:37 pm |
| A table doesn't have a collation. It is the columns in the table that has collations. To change
collation for a column, you use ALTER TABLE ... ALTER COLUMN. There is no way to do this using ALTER
at the table level.
Or, create a new table with proper collation and copy over data, rename old table, rename new table
to the original name. And handle constraints, indexes etc.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Cenk FIRAT" <Cenk FIRAT@discussions.microsoft.com> wrote in message
news:E0070291-5B6D-47D6-A8D8- 1643BE1482B6@microso
ft.com...
> Hi,
> I have tables (it has data) and i want to change table collation (not column
> collation)
> is it possible? if possible how i can change table collation?
>
> Thanks,
> Cenk FIRAT
|
|
|
|
|