Business
Engineering
Math
Science
Social Science
Which command deletes a view?
A Guide to SQL
Solutions
A Guide to SQL
Which command deletes a view?
View:
The “VIEW” in the SQL (Structured Query Language) is a virtual table that does not exist physically. It is formed by a SQL statement that links one or more tables.
- The view is considered as derived table because the data is comes from one or more base tables.
- It is a logical representation of table, all the operations asked by user on a view are really done on the underlying base table.
- View provides security to tables in database.
Syntax for create a view:
CREATE VIEW View_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
Here,
- “CREATE”, “VIEW” are the keywords which are used to create a view for the attributes of table.
- “View_name” is a name of the view.
- “As” is the keyword to retrieve actual query.
- Define the query from “SELECT” keyword of the command.
Explanation of Solution
Command to delete a view:
The command “DROP VIEW” is to delete a view from database.
Syntax:
DROP VIEW View_name
Here,
- “DROP”, “VIEW” are the keywords which are used to delete a view...
Chapter 7 Solutions
Additional Engineering Textbook Solutions
Database Systems: Design, Implementation, & Management
Principles of Information Security (MindTap Course List)
Fundamentals of Information Systems
Database Systems: Design, Implementation, & Management
Fundamentals of Information Systems
Principles of Information Systems (MindTap Course List)
Fundamentals of Geotechnical Engineering (MindTap Course List)
Precision Machining Technology (MindTap Course List)
Automotive Technology: A Systems Approach (MindTap Course List)
Cornerstones of Financial Accounting
Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)
Mechanics of Materials (MindTap Course List)
Principles of Geotechnical Engineering (MindTap Course List)
Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)
Management Of Information Security
Electric Motor Control
EBK ELECTRICAL WIRING RESIDENTIAL
Solid Waste Engineering
International Edition---engineering Mechanics: Statics, 4th Edition
Fundamentals of Chemical Engineering Thermodynamics (MindTap Course List)
Automotive Technology
Steel Design (Activate Learning with these NEW titles from Engineering!)
A+ Guide to Hardware (Standalone Book) (MindTap Course List)
Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)
Structural Analysis
Network+ Guide to Networks (MindTap Course List)
Welding: Principles and Applications (MindTap Course List)
