Creating databases
suggest changeSyntax
- CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_specification] /// To create database
- DROP {DATABASE | SCHEMA} [IF EXISTS] db_name /// To drop database
Parameters
|Parameter |Details | |––––––––––|————————| |CREATE DATABASE | Creates a database with the given name | CREATE SCHEMA | This is a synonym for CREATE DATABASE
|IF NOT EXISTS | Used to avoid execution error, if specified database already exists |create_specification| create_specification
options specify database characteristics such as CHARACTER SET
and COLLATE
(database collation)
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents