USE master;
GO
ALTER DATABASE AdventureWorks2022
Modify Name = Northwind ;
GO
USE master;
GO
CREATE DATABASE testdb
COLLATE SQL_Latin1_General_CP1_CI_AS ;
GO
ALTER DATABASE testDB
COLLATE French_CI_AI ;
GO
ALTER {DATABASE | SCHEMA} [db_name]
alter_option ...
alter_option: {
[DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_name
[DEFAULT] ENCRYPTION [=] {'Y' | 'N’}
| READ ONLY [=] {DEFAULT | 0 | 1}
}
