ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-54
CREATE TABLE
Specifying the Physical Location
In NonStop SQL/MP, you can specify the physical location of the index. In programs
used with the NonStop ODBC Server, you cannot; you can create an index only on the
subvolume that holds the catalog in which the index will be registered. You can,
however, specify the physical location by using the pass-through mode.
The following statements create three indexes on the PERSNL subvolume on the disk
volume DISK01 on the node TEST:
use test_disk01_persnl
create unique index xdeptnum
on dept (deptnum)
create index xdeptmgr
on dept (manager)
create index xdeptrpt
on dept (rptdept)
The indexes are registered in the catalog on that subvolume.
CREATE TABLE
Use CREATE TABLE to create new tables.
The file security for the table is obtained from the default permissions associated with
the user’s logon name.
The CREATE TABLE statement has the following syntax:
table-name
is the table to be created. The table-name can be qualified with the database
name and owner name. The fully expanded table name must be unique in the
network.
If the owner-name is omitted, the current user’s name is used.
You can specify a temporary table by preceding the table name with a number sign
(#). Temporary tables are dropped at the end of the NonStop ODBC Server
session.
CREATE TABLE [ [database.]owner. ] table-name
( column-name data-type [ NOT NULL ]
[ NULL ]
[ , column-name data-type [ NOT NULL ] ] ... )
[ NULL ]