Progress
SQL-89
Guide and Reference


CREATE SCHEMA Statement (ESQL Only)

Creates tables and views and grants privileges on them. The database in which the schema is created must be connected when you execute the CREATE SCHEMA statement.

SYNTAX
CREATE SCHEMA AUTHORIZATION db-user
  {   CREATE-TABLE-statement
    | CREATE-VIEW-statement
    |  GRANT-statement
  } ...  

db-user

This term serves as a logical database name, a user ID, and a password. When you execute the CREATE SCHEMA statement, Progress searches for a connected database with the logical name db-user. It then establishes db-user as the user ID and password for that database connection.

CREATE-TABLE-statement

A CREATE TABLE statement describing a table to be created in the database.

CREATE-VIEW-statement

A CREATE VIEW statement describing a view to be created in the database.

GRANT-statement

A GRANT statement granting privileges on a table or view to the owner of the table or view (or any user who holds the GRANT OPTION on the table or view).

NOTES

SEE ALSO

CREATE TABLE Statement, CREATE VIEW Statement, GRANT Statement


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095