|
|
|
|
|
|
|
|
|
|
version 11
{primary_key_definition | foreign_key_definition}
Description
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).
Example
This example sets Name as the primary key field:
CREATE TABLE ACTOR_FANS (ID INT32, Name VARCHAR NOT NULL UNIQUE);See Also
CREATE TABLE, foreign_key_definition, primary_key_definition.
|
|
|
|
|
|
|
|
|
|