https://www.omnidex.com/docs/v54/ 2026-04-29T23:33:38+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:statements:create_table:examples&rev=1467153531&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL: CREATE TABLE Description | Syntax | Topics | Examples Examples CREATE ENVIRONMENT and CREATE DATABASE have to be specified before specifying CREATE TABLE. The IN “filespec.xml” clause has to be specified after the column definitions. Tables must be declared in order of their constraints. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:statements:create_table:home&rev=1467153531&do=diff Omnidex SQL Quicklinks Overview Statements Functions Examples Quick Reference Omnidex SQL: CREATE TABLE Overview | Syntax | Examples Overview The CREATE TABLE statement declares a table in an Omnidex Environment File. Tables that are declared in an environment can then be indexed and retrieved using SQL statements. An Omnidex table can point to an underlying Oracle, SQL Server, MySQL or ODBC table or view. An Omnidex table can also point to one or more raw data files that match… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:statements:create_table:syntax&rev=1467153531&do=diff Omnidex SQL Quicklinks Overview Statements Functions Examples Quick Reference Omnidex SQL: CREATE TABLE Overview | Syntax | Examples Syntax CREATE [ < GLOBAL | LOCAL > ] TEMPORARY ] TABLE table [ NODE node] [ OPTIONS "options" ] [ PHYSICAL < "filespec" | rdbms_table > ] [ DATA_CACHING < DYNAMIC | NONE > ] [ PARTITION_BY "criteria" ] [ INDEX_MAINTENANCE < API | DBMS > ] ( column_specification, [ constraint_specif… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:statements:create_table:topics&rev=1467153531&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL: CREATE TABLE Overview | Syntax | Topics | Examples Special Topics * Temporary Tables * Database-specific Issues * Oracle * SQL Server * MySQL * ODBC * Raw Data Files - Fixed-length files * Raw Data Files - Delimited files * Raw Data Files - Omnidex Standalone Tables (OST's)