SQL Guide
:
Using SQL for database administration
:
Managing database objects
: Setting a catalog and schema context
Setting a catalog and schema context
The following example sets a catalog context to C and the schema context to S.
SET CATALOG C;
SET SCHEMA S;
CREATE TABLE T (i INTEGER);
SELECT * FROM T;
-- The name T is resolved to C.S.T
See also
Managing database objects
This site works best with JavaScript enabled