Constraints	Recital	MySQL	VFP
<table constraint>
ONCLOSE <procedure>	√
ONDELETE <procedure>	√
ONINSERT <procedure>	√
ONOPEN <procedure>	√
ONROLLBACK <procedure>	√
ONUPDATE <procedure>	√
INDEX <index> (column, ...)	√	√	√
KEY <index> (column, ...)	√	√	√
PRIMARY KEY (column, ...)	√	√	√
PRIMARY KEY <name> TAG <expr>	√		√
UNIQUE [ INDEX ] <index> (column, ...)	√	√	√
FULLTEXT [ INDEX ] <index> (column, ...)		√
[CONSTRAINT <symbol>]		√
FOREIGN KEY [ <name> ]	√	√	√
[ TAG ]	√		√
(<column>,...)	√	√	√
[ SAVE ]	√		√
[  NODUP ]	√		√
REFERENCES <table>	√	√	√
[ TAG ]	√		√
[ (<column>,...) ]	√	√	√
[ MATCH FULL | MATCH PARTIAL ]		√
[ ON DELETE		√
RESTRICT		√
CASCADE		√
SET NULL		√
NO ACTION		√
SET DEFAULT ]		√
[ ON UPDATE		√
RESTRICT		√
CASCADE		√
SET NULL		√
NO ACTION		√
SET DEFAULT ]		√
CHECK (expr)	√	√	√
NOVALIDATE	√		√
<field constraint>
CALCULATED(<expr>)	√
CHECK( <condition> )	√
SET CHECK <expr>	√		√
DEFAULT <expr>	√	√	√
DESCRIPTION <expC>	√
ERROR <message>	√		√
NOT NULL	√	√	√
FOREIGN KEY	√
[  NODUP ]	√		√
PRIMARY KEY	√	√	√
REFERENCES table(<key>)	√		√
RANGE(<expr1>,<expr2>)	√
RECALCULATE	√
UNIQUE	√		√
NULL	√	√	√
AUTO_INCREMENT	√	√
REFERENCES <table> [ (<column>,...) ]	√	√
[ MATCH FULL | MATCH PARTIAL ]		√
[ ON DELETE		√
RESTRICT		√
CASCADE		√
SET NULL		√
NO ACTION		√
SET DEFAULT ]		√
[ ON UPDATE		√
RESTRICT		√
CASCADE		√
SET NULL		√
NO ACTION		√
SET DEFAULT ]		√
AUTOINC	√		√
[ NEXTVALUE <NextValue>	√		√
[ STEP <StepValue> ] ]	√		√
COLLATE <cCollateSequence>	√		√
NOCPTRANS	√		√
NOVALIDATE	√		√
<data type>
BIGINT	√	√
[ ( <precision>	√	√
[  , <scale>  ]  )  ]	√
[ UNSIGNED ]	√	√
[ ZEROFILL ]		√
BIT	√
CHAR(size)	√	√	√
[ BINARY ]	√	√
DATE	√	√	√
DECIMAL	√	√
[ ( <precision>	√	√
[  , <scale>  ]  )  ]	√	√
[ UNSIGNED ]	√	√
[ ZEROFILL ]		√
DOUBLE	√	√	√
[ PRECISION ]	√
[ ( <precision>	√	√
[  , <scale>  ]  )  ]	√	√
[ UNSIGNED ]	√	√
[ ZEROFILL ]		√
FLOAT	√	√	√
[ ( <precision>	√	√	√
[  , <scale>  ]  )  ]	√	√	√
[ UNSIGNED ]	√	√
[ ZEROFILL ]		√
INT [EGER]	√	√	√
[ ( <precision>	√	√
[  , <scale>  ]  )  ]	√
[ UNSIGNED ]	√	√
[ ZEROFILL ]		√
LONG VARCHAR	√
LONG VARBINARY	√
NUMERIC	√	√	√
[ ( <precision>	√	√	√
[  , <scale>  ]  )  ]	√	√	√
[ UNSIGNED ]	√	√
[ ZEROFILL ]		√
REAL	√	√
[ ( <precision>	√	√
[  , <scale>  ]  )  ]	√	√
[ UNSIGNED ]	√	√
[ ZEROFILL ]		√
SMALLINT	√	√
[ (length) ]	√	√
[ UNSIGNED ]	√	√
[ ZEROFILL ]		√
SHORT(p,s)	√
TINYINT	√	√
[ (length) ]	√	√
[ UNSIGNED ]	√	√
[ ZEROFILL ]		√
VARCHAR(size)	√	√
[ BINARY ]	√	√
MEDIUMINT	√
[ ( <precision>	√	√
[  , <scale>  ]  )  ]	√
[ UNSIGNED ]	√	√
[ ZEROFILL ]		√
TIME	√	√
TIMESTAMP	√	√
DATETIME		√	√
TINYBLOB		√
BLOB		√
MEDIUMBLOB		√
LONGBLOB		√
TINYTEXT		√
TEXT	√	√
MEDIUMTEXT		√
LONGTEXT		√
ENUM(value1,value2,value3,...)		√
SET(value1,value2,value3,...)		√
CURRENCY			√
LOGICAL	√		√
MEMO	√		√
GENERAL			√
PICTURE			√
PSEUDO COLUMNS	√
CURRVAL	√
NEXTVAL	√
LEVEL	√
ROWID	√
ROWNUM	√
SQLCNT	√
SQLCODE	√
SQL Comparison Tables
Copyright © 2005 Recital Corporation. All rights reserved.
http://www.recital.com