primary_key_definition

Dies ist die alte 4D Dokumentations-Website. Die neue und aktualisierte Dokumentation finden Sie unter developer.4d.com

Home

4D - SQL Reference
- Syntax rules
- - Syntax rules
  - 4d_function_call
  - 4d_language_reference
  - all_or_any_predicate
  - arithmetic_expression
  - between_predicate
  - case_expression
  - column_definition
  - column_reference
  - command_parameter
  - comparison_predicate
  - exists_predicate
  - foreign_key_definition
  - function_call
  - in_predicate
  - is_null_predicate
  - like_predicate
  - literal
  - predicate
  - primary_key_definition
  - search_condition
  - select_item
  - sort_list
  - sql_data_type_name
  - sql_name
  - sql_string
  - subquery
  - table_constraint
  - table_reference

Home

4D v20 R7

4D - SQL Reference

Syntax rules

primary_key_definition



	Command primary_key_definitio[CONSTRAINT sql_name] PRIMARY KEY (sql_name, ... , sql_name)

Description

A primary_key_definition is used to pass the column or combination of columns (sql_name) that will serve as the PRIMARY KEY (unique ID) for the table. The column(s) passed must not contain duplicate or NULL values.

An optional CONSTRAINT can also precede the PRIMARY KEY passed in order to limit the values that can be inserted into the column.

Example

This example creates a table and sets the SID column as the primary key:

CREATE TABLE Customer
(SID int32,
Last_Name varchar(30),
First_Name varchar(30),
PRIMARY KEY (SID));

Siehe auch

ALTER TABLE
foreign_key_definition

Vorige Seite

Nächste Seite

EIGENSCHAFTEN

Produkt: 4D
Thema: Syntax rules

SEITENINHALT

Description

Example

GESCHICHTE

ARTIKELVERWENDUNG

4D - SQL Reference ( 4D v20 R7)

Fehler melden