You can apply the SQL CREATE statement to a large number of SQL objects, including schemas, domains, tables, and views. By using the CREATE SCHEMA statement, you can not only create a schema but also identify its owner and specify a default character set.

EXAMPLE:

     CREATE SCHEMA SALES

        AUTHORIZATION SALES_MGR

        DEFAULT CHARACTER SET ASCII_FULL ;

The CREATE TABLE statement is used to create a new table in a database.

EXAMPLE:

     CREATE TABLE table_name (

        column1 datatype,

        column2 datatype,

        column3 datatype,

        . . . .

     );

Use the CREATE DOMAIN statement to apply constraints to column values. The constraints you apply to a domain determine what objects the domain can and cannot contain. You can create domains after you establish a schema.

EXAMPLE:

          CREATE DOMAIN Age AS INTEGER

                CHECK ( AGE > 20) ;

You create tables by using the CREATE TABLE statement, and you create views by using the CREATE VIEW statement. When you use the CREATE TABLE statement, you can specify constraints on the new table’s columns at the same time.