Ultimate access to all questions.
Which SQL keyword is used to modify the schema or properties of an existing Delta table?
Explanation:
The ALTER TABLE
command is used to change the schema or properties of a table. If the table is cached, this command clears cached data of the table and all its dependents that refer to it. The cache will be lazily filled when the table or the dependents are accessed the next time. Required permissions vary depending on the operation, with some requiring MODIFY
permission and others requiring ownership of the table. The correct answer is ALTER
. Learn more: ALTER TABLE | Databricks.