(Top QUALITY 2024/2025 EXAM REVIEW) WGU C170 Data Management - Applications SQL Syntax. APPROVED. CREATE TABLE syntax
WGU C170 Data Management - Applications SQL Syntax. APPROVED. 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 ON tableName (colName, colName)
Written for
- Institution
- Western Governors University
- Course
- WGU C170 - Data Management – Applications
Document information
- Uploaded on
- November 2, 2023
- Number of pages
- 4
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
wgu c170 data management applications sql syntax
Also available in package deal