|
SQL BASIC
|
|
|
|
DATA QUERY LANGUAGE
|
|
|
|
BASIC FUNCTION
|
|
|
|
AGGREGATE FUNCTION
|
|
|
|
DATA MANIPULATION LANGUAGE
|
|
|
|
DATA DEFINITION LANGUAGE
|
|
|
|
DATA CONTROL LANGUAGE
|
|
|
|
OTHERS
|
|
|
|
|
|
|
|
CREATE DATABASE
|
CREATE DATABASE <database_name> [option];
|
Database is the first object you must create before you can create
any other database objects. The syntax of creating a new database is as shown
above. Please take note that there [option] parameters differs from vendor to
vendor. It usually accept the file name where the physical file is stored and
database size.
|
|