SQL Create DataBase
The CREATE DATABASE Statement is used to create a database. After creating a database, we can create several other database objects (tables, views, procedures etc.) into it. The user should have admin privileges for creating database.:
SQL CREATE DATABASE Statement:
CREATE DATABASE database_name
[COLLATE collation_name ]
In the above query,
- database_name - is the name of the database to be created
- collation_name - is the default collation (character set) for the database.
This, collation_name, is an optional field and if not provided then Default Collation is assigned to database.
CREATE DATABASE Example:
- If you want to create database MyDatabase with default collation, the statement would be like
- If you want to create database MyOtherDatabase with collation “Latin General” then statement would be like
CREATE DATABASE MyDatabase ;
CREATE DATABASE MyOtherDatabase