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.
DESCRIBE MASKING POLICY
Describes the details about a masking policy, including the creation date, name, data type, and SQL expression.
DESCRIBE MATERIALIZED VIEW
Describes the columns in a materialized view.
DESCRIBE ROW ACCESS POLICY
Describes a row access policy, including the creation date, name, data type, and SQL expression.
DESCRIBE SEARCH OPTIMIZATION
Describes thesearch optimization configurationfor a specified table and its columns.
DESCRIBE SEQUENCE
Describes a sequence, including the sequence’s interval.
DESCRIBE TABLE
Describes either the columns in a table or the current values, as well as the default values, for the stage properties for a table.
DESCRIBE VIEW
Describes the columns in a view (or table).
DROP EXTERNAL TABLE
Removes an external table from the current/specified schema.
DROP MASKING POLICY
Removes a masking policy from the system.
DROP ROW ACCESS POLICY
Removes a row access policy from the system.
DROP SEQUENCE
Removes a sequence from the current/specified schema.
DROP TABLE
Removes a table from the current/specified schema, but retains a version of the table so that it can be recovered usingUNDROP TABLE.
DROP VIEW
Removes the specified view from the current/specified schema.
SELECT
SELECT can be used as either a statement or as a clause within other statements.
SHOW COLUMNS
Lists the columns in the tables or views for which you have access privileges.
SHOW EXTERNAL TABLES
Lists the external tables for which you have access privileges.
SHOW MASKING POLICIES
Lists masking policy information, including the creation date, database and schema names, owner, and any available comments.
SHOW MATERIALIZED VIEWS
Lists the materialized views that you have privileges to access.
SHOW OBJECTS
Lists the tables and views for which you have access privileges.
SHOW PRIMARY KEYS
Lists primary keys for the specified table, or for all tables in the current or specified schema, or for all tables in the current or specified database, or for all tables in the current account.
SHOW ROW ACCESS POLICIES
Lists the row access policies for which you have access privileges.
SHOW SEQUENCES
Lists all the sequences for which you have access privileges.
SHOW TABLES
Lists the tables for which you have access privileges, including dropped tables that are still within the Time Travel retention period and, therefore, can be undropped.
SHOW VIEWS
Lists the views, including secure views, for which you have access privileges.
TRUNCATE MATERIALIZED VIEW
Removes all rows from a materialized view, but leaves the view intact (including all privileges and constraints on the materialized view).
UNDROP TABLE
Restores the most recent version of a dropped table.
