Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
dev:sql:statements:create_table:home [2010/07/06 19:42]
els
dev:sql:statements:create_table:home [2016/06/28 22:38] (current)
Line 1: Line 1:
 {{page>:​top_add&​nofooter&​noeditbtn}} {{page>:​top_add&​nofooter&​noeditbtn}}
-<​html><​div align="​center"><​span style="​color:​red">​DRAFT</​span></​div></​html>​ 
  
-{{page>:sql_bar&​nofooter&​noeditbtn}}+ 
 +^ Omnidex SQL Quicklinks ^^^^^ 
 +|[[dev:sql:​overview | Overview ]] | [[dev:​sql:​statements:​home | Statements ]] | [[ dev:​sql:​functions:​home | Functions ]] | [[ dev:​sql:​examples:​home | Examples ]] | [[dev:​sql:​home | Quick Reference ]] | 
  
 ====== Omnidex SQL: CREATE TABLE ====== ====== Omnidex SQL: CREATE TABLE ======
  
-**[[dev:​sql:​statements:​create_table:​home|Description]]** -> [[dev:​sql:​statements:​create_table:​syntax|Syntax]] ​-> [[dev:​sql:​statements:​create_table:​examples|Examples]]+**[[dev:​sql:​statements:​create_table:​home|Overview]]** [[dev:​sql:​statements:​create_table:​syntax|Syntax]] ​[[dev:​sql:​statements:​create_table:​examples|Examples]] 
  
 ===== Overview ===== ===== Overview =====
Line 16: Line 19:
 ===== Table Characteristics ===== ===== Table Characteristics =====
  
-The CREATE TABLE statement declares the characteristics of the table. ​ At a minimum, each table has a name and instructions for accessing the physical data.  Omnidex supports configuration settings for each table, including settings for [[dev:​sql:​statements:​create_table:​delimited_files | delimited files]], [[dev:​sql:​statements:​create_table:​data_cache | data caches ]] and [[dev:​sql:​statements:​create_table:​index_maintenance | index maintenance]]. Omnidex also provides [[dev:sql:statements:create_table:​rollup_tables ​| rollup tables]] which pre-aggregate another table in the database and automatically optimize queries against the table. ​   ​+The CREATE TABLE statement declares the characteristics of the table. ​ At a minimum, each table has a name and instructions for accessing the physical data.  Omnidex supports configuration settings for each table, including settings for [[dev:​sql:​statements:​create_table:​delimited_files | delimited files]], [[dev:​sql:​statements:​create_table:​data_cache | data caches ]] and [[dev:​sql:​statements:​create_table:​index_maintenance | index maintenance]]. Omnidex also provides [[admin:features:rollups:home | rollup tables]] which pre-aggregate another table in the database and automatically optimize queries against the table. ​   ​
  
 ===== Columns Characteristics ===== ===== Columns Characteristics =====
Line 29: Line 32:
  
 Like most databases, Omnidex allows indexes to be declared using the CREATE INDEX statement. ​ For convenience,​ Omnidex also allows indexes to be declared using the CREATE TABLE statement. ​ In most applications,​ many (if not all) of the columns are indexed with Omnidex, so it is convenient to declare the indexing directly in the table specification. ​ Like most databases, Omnidex allows indexes to be declared using the CREATE INDEX statement. ​ For convenience,​ Omnidex also allows indexes to be declared using the CREATE TABLE statement. ​ In most applications,​ many (if not all) of the columns are indexed with Omnidex, so it is convenient to declare the indexing directly in the table specification. ​
- 
 ===== Inlining ===== ===== Inlining =====
  
-Omnidex allows constraints and indexing to be declared alongside each column. ​ With [[dev:​sql:​statements:​create_table:​inlining ​| inlining]], the constraint and indexing specification is provided as each column is declared. This is a convenience for simple installations where most constraints and indexes consist of a single column. ​+Omnidex allows constraints and indexing to be declared alongside each column. ​ With inlining, the constraint and indexing specification is provided as each column is declared. This is a convenience for simple installations where most constraints and indexes consist of a single column. ​
   ​   ​
 +
 +====== Additional Resources ======
 +See also: 
 +  * [[dev:​sql:​statements:​create_environment:​home|CREATE ENVIRONMENT]]
 +  * [[dev:​sql:​statements:​create_database:​home|CREATE DATABASE]]
 +  * [[dev:​sql:​statements:​create_index:​home|CREATE INDEX]]
 +  * [[dev:​sql:​statements:​update_indexes:​home|UPDATE INDEXES]]
 +
 +Articles:
 +
 +  * [[admin:​indexing:​home|Indexing Strategies]]
 +  * [[dev:​appendix:​articles:​dbspe|Database-specific issues]]
 +  * [[admin:​features:​rollups:​home|Rollup Tables]]
 +
 +
 {{page>:​bottom_add&​nofooter&​noeditbtn}} {{page>:​bottom_add&​nofooter&​noeditbtn}}
 
Back to top
dev/sql/statements/create_table/home.1278445367.txt.gz · Last modified: 2016/06/28 22:38 (external edit)