Views in Database | American Baptist College - Edubirdie

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

2023
Views:

371

Pages:

1
Author:

Muthia M.

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

Views in Database

Views in Database - Page 1

of 1

Recommended Documents

ITS Databases Practice Exam 25

ITS Databases Practice Exam 25

American Baptist College CSCI 1534 | Data Analysis and Visualization

Assignment

New Documents from this Course

UNION and UNION ALL

UNION and UNION ALL

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Input and Output Operation in Python

Input and Output Operation in Python

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Python Data Operator (Assignment Operators and Comparison Operators)

Python Data Operator (Assignment Operators and Comparison Operators)

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Operations using Data Types and Operators in Python

Operations using Data Types and Operators in Python

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Intersect, Distinct, Alias, Computed Column and Sort

Intersect, Distinct, Alias, Computed Column and Sort

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Flow Control with Iteration (While Statement and For Statement)

Flow Control with Iteration (While Statement and For Statement)

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Flow Control with Desicions

Flow Control with Desicions

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Aggregate in Database

Aggregate in Database

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Data Protection Measures

Data Protection Measures

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Datamart to Looking for the Profit Every Month

Datamart to Looking for the Profit Every Month

American Baptist College CSCI 1534 | Data Analysis and Visualization

Assignment