C170 Data Management - Applications SQL Syntax, Questions & Answers. VERIFIED.
C170 Data Management - Applications SQL Syntax, Questions & Answers. VERIFIED. 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 indexName ON tableName (colName); UNIQUE should only be used on a column that should not have duplicate values. DROP INDEX syntax DDL - -DROP INDEX indexName; DROP INDEX 'PRIMARY' ON tableName; drops PK ALTER INDEX DDL - -ALTER INDEX indexName
Written for
- Institution
- Western Governors University
- Course
- WGU C170 Data Management
Document information
- Uploaded on
- August 23, 2023
- Number of pages
- 4
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
c170 data management applications sql syntax qu
Also available in package deal