hi,
i want to delete all column collation in database !
how can i do ?
thank'sEvery column of a string datatype has a collation associated with it. You cannot "delete the
collation" without also removing that column. Can you elaborate on what you want to achieve?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ch." <trotroyanas@.hotmail.com> wrote in message news:Ooimr$C0GHA.1292@.TK2MSFTNGP03.phx.gbl...
> hi,
> i want to delete all column collation in database !
> how can i do ?
> thank's
>
>|||Hi,
If the problem is that the column has 1 type of collation specified for it,
and you wish to change it (e.g. to the default collation for the database),
then the following might help ...
ALTER TABLE <tablename>
ALTER COLUMN <name>
<datatype> COLLATE <new collation e.g. Latin1_General_CI_AS>
... <other column options>
GO
Sources of information for this include 'Collations, changing' in SQL 2000
BOL and 'How To: Set Column Collation' in SQL 2005 BOL
Collation can be changed both through T-SQK or in SSMS
Hope the above helps
Craig
"Ch." wrote:
> hi,
> i want to delete all column collation in database !
> how can i do ?
> thank's
>
>|||yes it's my problem
i have make script to drop index
and alter procedure for all column have a collation but i have new problem !
i want to re create a index (drop before the alter)
how can i do, for scripting create index of tables ?
i know a table who have à index dropped !
i search a script who waiting table in parameters and return
script to create index ? (before drop of course)
!
"craig_amtdatatechnologies@.discussions.mi"
<craigamtdatatechnologiesdiscussionsmi@.discussions.microsoft.com> a écrit
dans le message de news:
7C701026-9D52-4DBE-A425-43109BE4D0C3@.microsoft.com...
> Hi,
> If the problem is that the column has 1 type of collation specified for
> it,
> and you wish to change it (e.g. to the default collation for the
> database),
> then the following might help ...
>
> ALTER TABLE <tablename>
> ALTER COLUMN <name>
> <datatype> COLLATE <new collation e.g. Latin1_General_CI_AS>
> ... <other column options>
> GO
> Sources of information for this include 'Collations, changing' in SQL 2000
> BOL and 'How To: Set Column Collation' in SQL 2005 BOL
> Collation can be changed both through T-SQK or in SSMS
> Hope the above helps
> Craig
>
> "Ch." wrote:
>> hi,
>> i want to delete all column collation in database !
>> how can i do ?
>> thank's
>>
>>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment