Create table : Create Table : Table Index SQL / MySQL

Ajax
Ajax Examples Ajax Tutorials Scripts and Programs
Javascript
Javascript Examples Tutorials DHTML Tutorials Javascript References Scripts and Programs
HTML
HTML Tutorials HTML References HTML DOM 0 References HTML DOM 2 References
CSS
CSS Tutorials CSS References
PHP
PHP Source Code PHP References Scripts and Programs
C#
C# Source Code C# Examples

SQL / MySQL » Table Index » Create Table »

Create table



Drop table Orders;

CREATE TABLE Orders
(
   ID SMALLINT UNSIGNED NOT NULL PRIMARY KEY,
   ModelID SMALLINT UNSIGNED NOT NULL,
   Desciption VARCHAR(40),
   FOREIGN KEY (ModelID) REFERENCES Models (ModelID)
      ON DELETE CASCADE ON UPDATE CASCADE
);

Describe Orders;