Adds database-specific options after the final column definition in a CREATE TABLE statement.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Data source: | MySQL |
| Note: | Support for this data set option was added in SAS 9.4M9. |
Table of Contents
specifies a database-specific option to be placed after the final column definition in a CREATE TABLE statement. If you specify more than one option, use a comma to separate the options.
The POST_COLUMN_OPTS= option enables you to specify one or more options that are placed after the final column definition in the generated CREATE TABLE statement. These options are specific to the database. For example, MySQL supports constraints such as PRIMARY KEY and UNIQUE. For more information, see the database documentation.