IT C170 C170 58 Question Multi-Choice OA Study Guide SQL Commands
Document Content and Description Below
ALTER VIEW This statement changes the definition of a view, which must exist. The syntax is similar to that for CREATE VIEW see Section 13.1.21, “CREATE VIEW Statement”). This statement requires... the CREATE VIEW and DROP privileges for the view, and some privilege for each column referred to in the SELECT statement. ALTER VIEW is permitted only to the definer or users with the SUPER privilege. ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] DROP VIEW DROP VIEW removes one or more views. You must have the DROP privilege for each view. DROP VIEW [IF EXISTS] view_name [, view_name] ... [RESTRICT | CASCADE] CREATE INDEX/DROP INDEX The CREATE INDEX statement is used to create indexes in tables. CREATE INDEX index_name ON table_name (column1, column2, ...); The DROP INDEX statement is used to delete an index in a table. MS Access: DROP INDEX index_name ON table_name [Show More]
Last updated: 2 years ago
Preview 1 out of 16 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$7.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Sep 17, 2021
Number of pages
16
Written in
Additional information
This document has been written for:
Uploaded
Sep 17, 2021
Downloads
0
Views
322
