Exam (elaborations)
C170 Data Management - Applications SQL Syntax
- Course
- Institution
CREATE TABLE syntax DDL CREATE TABLE tableName ( colName dataType constraint INDEX indexName (colName) PRIMARY KEY (colName, colName) or colName dataType PRIMARY KEY FOREIGN KEY (colName, colName) REFERENCES tableName (colName) ); CREATE INDEX syntax DDL CREATE [UNIQUE] INDEX ind...
[Show more]