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.

Comments are closed.

Sorry, the comment form is closed at this time.