June 24th, 2009
Data Definition Language, CREATE SCHEMA
Posted by
admin in
Q. Data Definition Language
Format:
CREATE SCHEMA schema_name [user_id]
[DEFAULT CHARACTER SET char_set_name];
A schema is a set of database objects that is owned by a user called a schema owner.
The schema owner has authority to give privileges to other users.
Example:
CREATE SCHEMA CBT_INC USER1;
> All RDBMS vendors have their own parameters for defining a schema.
