Embedded Usage

In an embedded CREATE TABLE statement:

• Host language variables can be used to specify constant expressions in the subselect of a CREATE TABLE...AS SELECT statement.
• Location_name can be specified using a host language string variable.
• The preprocessor does not validate the syntax of the with_clause.

Permissions

All users. Using the grant statement, the DBA can control whether specific users, groups, or roles can create tables.

Locking

The DBMS Server takes an exclusive table lock when creating a table, which prevents other sessions—even those using READLOCK=NOLOCK—from accessing the table until the transaction containing the CREATE TABLE statement is committed.

Related Statements

Alter Table

Create Index

Create Integrity

Create Location

Drop

Grant (privilege)

Help

Modify

Select (interactive)

[No]Journaling