The MSDN page
states
-- Azure SQL Database Syntax
ALTER DATABASE database_name
{
MODIFY NAME =new_database_name
| MODIFY ( <edition_options> [, ... n] )
| COLLATE collation_name
| SET { <set_database_options> }
}
<edition_options> ::=
{
MAXSIZE = { 100 MB | 500 MB |1 | 5 | 10 | 20 | 30 … 150 … 500 } GB
| EDITION = { 'web' | 'business' | 'basic' | 'standard' | 'Premium' }
| SERVICE_OBJECTIVE = { 'shared' | 'basic' | 'S0' | 'S1' | 'S2' | 'P1' | 'P2' | 'P3' }
}
<set_database_options> ::=
<db_update_option>
<db_update_option> ::=
{ READ_ONLY | READ_WRITE }
[;]
I tried the following, however they are all failing with syntax errors
ALTER DATABASE SCRATCH1
{
MODIFY (EDITION = 'STANDARD' , SERVICE_OBJECTIVE = 'S0')
};
ALTER DATABASE SCRATCH1
{
MODIFY (EDITION = 'STANDARD' | SERVICE_OBJECTIVE = 'S0')
};
ALTER DATABASE SCRATCH1
MODIFY (EDITION = 'STANDARD' , SERVICE_OBJECTIVE = 'S0');
ALTER DATABASE SCRATCH1
MODIFY (EDITION = 'STANDARD' | SERVICE_OBJECTIVE = 'S0');
Clearly I'm misinterpreting the MSDN doc, so, what is the correct syntax?
Aucun commentaire:
Enregistrer un commentaire