SQL/MX Quick Start (H06.04+, J06.03+)

HP NonStop SQL/MX Quick Start—540438-001
9-1
9 Creating Database Objects
This section describes how to create and drop objects in your database.
You use the Data Definition Language (DDL) statements of NonStop SQL/MX to create
database objects. For more information about DDL statements, see the SQL/MX
Reference Manual.
Creating a Catalog
Before you can create an SQL/MX table, you must first create a catalog and a schema
in which to store the definition of the table. You can use MXCI to create these objects.
For information about starting MXCI, see Starting MXCI on page 1-1.
Example
Create a catalog named MYCAT on the current node and volume. At the MXCI prompt,
enter:
CREATE CATALOG MYCAT;
--- SQL operation complete.
SET CATALOG MYCAT;
--- SQL operation complete.
CREATE SCHEMA MYSCH;
--- SQL operation complete.
SET SCHEMA MYSCH;
--- SQL operation complete.