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.
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
- You can execute the CREATE SCHEMA statement only from ESQL. You cannot use it in interactive SQL.
- When the CREATE SCHEMA statement is executed, Progress searches for a database with the specified logical name. It creates the alias DICTDB for that database. It then sets the user ID for that database connection to the logical name you specified. It also uses that name as a password.
- Each CREATE TABLE, CREATE VIEW, and GRANT statement within a CREATE SCHEMA statement is executed separately. If an error occurs in one statement, that specific statement is undone and the CREATE SCHEMA is terminated. However, all previous schema changes are committed.
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 |