DDL Command in View | American Baptist College - Edubirdie

University:
American Baptist College
Course:
CSCI 1534 | Data Analysis and Visualization
Academic year:

2024
Views:

195

Pages:

1
Author:

Venesia A.

Views in Database In a database, a view is the result set of a stored query, which can be queried in the same manner as a persistent database collection object. This pre-established query command is kept in the data dictionary. DDL Command in View 1. CREATE CREATE VIEW view_name AS SELECT column1, column2, ... FROM table_name WHERE condition; 2. ALTER You can't directly change the design of an existing view. If you want to mak modifications, you usually have to delete the view and then create it again with the changes you want. 3. DROP DROP VIEW view_name; 4. TRUNCATE Views do not support the TRUNCATE operation. Truncation is typically used with physical tables, not views. 5. COMMENT COMMENT ON VIEW view_name IS 'Description of the view'; 6. RENAME ALTER VIEW old_view_name RENAME TO new_view_name;

Related Documents

DDL Command in View

DDL Command in View - Page 1

of 1

Recommended Documents

Protect Personal Data

Protect Personal Data

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Prescriptive Analytics

Prescriptive Analytics

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Predictive Analytics

Predictive Analytics

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Personal Data

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Motivational Bias and Sampling Bias

Motivational Bias and Sampling Bias

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Show more

New Documents from this Course

Protect Personal Data

Protect Personal Data

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Prescriptive Analytics

Prescriptive Analytics

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Predictive Analytics

Predictive Analytics

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Personal Data

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Motivational Bias and Sampling Bias

Motivational Bias and Sampling Bias

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

ITS Databases Practice Exam 25

ITS Databases Practice Exam 25

American Baptist College CSCI 1534 | Data Analysis and Visualization

Assignment

Show more