Foreign Key

Keyword FOREIGN KEY

AlaSQL supports FOREIGN KEY concept.

Syntax:

    CREATE TABLE tableid (
        columnid type REFERENCES reftableid (refcolumnid,...)
    );

In this example field Orders.fruitid reference to Fruits table:

     CREATE DATABASE Fruits;
      USE DATABASE Fruits;
      CREATE TABLE Fruits (
        fruitid INT PRIMARY KEY,
        fruitname NVARCHAR(MAX),
        price MONEY
      );

      CREATE TABLE Orders (
        orderid INT PRIMARY KEY IDENTITY,
        fruitid INT REFERENCES Fruits(fruitid),
        qty FLOAT
      );

See also: [PRIMARY KEY](Primary Key)