DBCREATE_TABLE_OPTS= Data Set Option

Specifies syntax to be added to the CREATE TABLE statement.

Valid in: DATA and PROC steps
Supports: MySQL

Syntax

DBCREATE_TABLE_OPTS=< 'SQL-clauses'>

Syntax Description

MySQL-specific-SQL-clauses

are one or more clauses that can be appended to the end of an SQL CREATE TABLE statement.

Details

This option enables you to add clauses to the end of the SQL CREATE TABLE statement. The engine passes the SQL CREATE TABLE statement and its clauses to MySQL, which executes the statement and creates the table. This option applies only when you are creating a table by specifying a libref that is associated with data.