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: 1 year ago

Preview 1 out of 16 pages