SQL Table View Sequence DDL Flashcards
ALTER EXTERNAL TABLE
Modifies the properties, columns, or constraints for an existing external table.
ALTER MASKING POLICY
Replaces the existing masking policy rules with new rules or a new comment and allows the renaming of a masking policy.
ALTER MATERIALIZED VIEW
Alters a materialized view in the current/specified schema.
ALTER ROW ACCESS POLICY
Modifies the properties for an existing row access policy, including renaming the policy or replacing the policy rules.
ALTER SEQUENCE
Modifies the properties for an existing sequence.
ALTER TABLE
Modifies the properties, columns, or constraints for an existing table.
ALTER TABLE … ALTER COLUMN
This topic describes how to modify one or more column properties for a table using anALTERCOLUMNclause in aALTER TABLEstatement.
ALTER VIEW
Modifies the properties for an existing view.
CREATE EXTERNAL TABLE
Creates a new external table in the current/specified schema or replaces an existing external table.
CREATE MASKING POLICY
Creates a new masking policy in the current/specified schema or replaces an existing masking policy.
CREATE MATERIALIZED VIEW
Creates a new materialized view in the current/specified schema, based on a query of an existing table, and populates the view with data.
CREATE ROW ACCESS POLICY
Creates a new row access policy in the current/specified schema or replaces an existing row access policy.
CREATE SEQUENCE
Creates a new sequence, which can be used for generating sequential, unique numbers.
CREATE TABLE
Creates a new table in the current/specified schema or replaces an existing table.
CREATE | ALTER TABLE … CONSTRAINT
This topic describes how to create constraints by specifying aCONSTRAINTclause in aCREATE TABLEorALTER TABLEstatement.
CREATE VIEW
Creates a new view in the current/specified schema, based on a query of one or more existing tables (or any other valid query expression).
DESCRIBE EXTERNAL TABLE
Describes the VALUE column and virtual columns in an external table.