Modify SQL Database collation Modify table field collation

Modify SQL Database collation Modify table field collation

To modify the SQL database collation:

1. Modify to Single user mode

2. Then close all the query Windows and modify the Collocation properties of the options, such as: Chinese_prc_90_ci_as

3. Re-modify to multiuser mode

To modify the table field collation:

Using stored procedure processing, you can specify the corresponding table,

Stored Procedure processing steps:

1-delete excluding keys (with corresponding SQL statements)

2-Delete primary key (including corresponding SQL statement)

2.5-delete index (including corresponding SQL statement)

3-Modify the collation (including the corresponding SQL statement)

4-Generate the main key (including the corresponding SQL statement)

5-Generate the external key (including the corresponding SQL statement)

6-Generate index (including corresponding SQL statement)

7-Execute the corresponding SQL statement and export or do not execute the corresponding SQL statement only export

Stored Procedure Downloads: