This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

 
Home
4D v20
4D SQL Reference
Syntax rules
table_constraint

table_constraint  


 

 

Command table_constraint{primary_key_definition | foreign_key_definition}

A table_constraint restricts the values that a table can store. You can either pass a primary_key_definition or a foreign_key_definition. The primary_key_definition sets the primary key for the table and the foreign_key_definition is used to set the foreign key (which matches the primary key of another table).



See also 

CREATE TABLE
foreign_key_definition
primary_key_definition

Previous page
Next page

 
PROPERTIES 

Product: 4D
Theme: Syntax rules

 
PAGE CONTENTS 
Description
 
HISTORY 

 
ARTICLE USAGE

4D SQL Reference ( 4D v20)