SQL Table View Sequence DDL

Question 1

ALTER EXTERNAL TABLE

Answer 1

Modifies the properties, columns, or constraints for an existing external table.

Question 2

ALTER MASKING POLICY

Answer 2

Replaces the existing masking policy rules with new rules or a new comment and allows the renaming of a masking policy.

Question 3

ALTER MATERIALIZED VIEW

Answer 3

Alters a materialized view in the current/specified schema.

Question 4

ALTER ROW ACCESS POLICY

Answer 4

Modifies the properties for an existing row access policy, including renaming the policy or replacing the policy rules.

Question 5

ALTER SEQUENCE

Answer 5

Modifies the properties for an existing sequence.

Question 6

ALTER TABLE

Answer 6

Modifies the properties, columns, or constraints for an existing table.

Question 7

ALTER TABLE … ALTER COLUMN

Answer 7

This topic describes how to modify one or more column properties for a table using anALTERCOLUMNclause in aALTER TABLEstatement.

Question 8

ALTER VIEW

Answer 8

Modifies the properties for an existing view.

Question 9

CREATE EXTERNAL TABLE

Answer 9

Creates a new external table in the current/specified schema or replaces an existing external table.

Question 10

CREATE MASKING POLICY

Answer 10

Creates a new masking policy in the current/specified schema or replaces an existing masking policy.

Question 11

CREATE MATERIALIZED VIEW

Answer 11

Creates a new materialized view in the current/specified schema, based on a query of an existing table, and populates the view with data.

Question 12

CREATE ROW ACCESS POLICY

Answer 12

Creates a new row access policy in the current/specified schema or replaces an existing row access policy.

Question 13

CREATE SEQUENCE

Answer 13

Creates a new sequence, which can be used for generating sequential, unique numbers.

Question 14

CREATE TABLE

Answer 14

Creates a new table in the current/specified schema or replaces an existing table.

Question 15

CREATE | ALTER TABLE … CONSTRAINT

Answer 15

This topic describes how to create constraints by specifying aCONSTRAINTclause in aCREATE TABLEorALTER TABLEstatement.

Question 16

CREATE VIEW

Answer 16

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).

Question 17

DESCRIBE EXTERNAL TABLE

Answer 17

Describes the VALUE column and virtual columns in an external table.

Question 18

DESCRIBE MASKING POLICY

Answer 18

Describes the details about a masking policy, including the creation date, name, data type, and SQL expression.

Question 19

DESCRIBE MATERIALIZED VIEW

Answer 19

Describes the columns in a materialized view.

Question 20

DESCRIBE ROW ACCESS POLICY

Answer 20

Describes a row access policy, including the creation date, name, data type, and SQL expression.

Question 21

DESCRIBE SEARCH OPTIMIZATION

Answer 21

Describes thesearch optimization configurationfor a specified table and its columns.

Question 22

DESCRIBE SEQUENCE

Answer 22

Describes a sequence, including the sequence’s interval.

Question 23

DESCRIBE TABLE

Answer 23

Describes either the columns in a table or the current values, as well as the default values, for the stage properties for a table.

Question 24

DESCRIBE VIEW

Answer 24

Describes the columns in a view (or table).

Question 25

DROP EXTERNAL TABLE

Answer 25

Removes an external table from the current/specified schema.

Question 26

DROP MASKING POLICY

Answer 26

Removes a masking policy from the system.

Question 27

DROP ROW ACCESS POLICY

Answer 27

Removes a row access policy from the system.

Question 28

DROP SEQUENCE

Answer 28

Removes a sequence from the current/specified schema.

Question 29

DROP TABLE

Answer 29

Removes a table from the current/specified schema, but retains a version of the table so that it can be recovered using UNDROP TABLE.

Question 30

DROP VIEW

Answer 30

Removes the specified view from the current/specified schema.

Question 31

SELECT

Answer 31

SELECT can be used as either a statement or as a clause within other statements.

Question 32

SHOW COLUMNS

Answer 32

Lists the columns in the tables or views for which you have access privileges.

Question 33

SHOW EXTERNAL TABLES

Answer 33

Lists the external tables for which you have access privileges.

Question 34

SHOW MASKING POLICIES

Answer 34

Lists masking policy information, including the creation date, database and schema names, owner, and any available comments.

Question 35

SHOW MATERIALIZED VIEWS

Answer 35

Lists the materialized views that you have privileges to access.

Question 36

SHOW OBJECTS

Answer 36

Lists the tables and views for which you have access privileges.

Question 37

SHOW PRIMARY KEYS

Answer 37

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.

Question 38

SHOW ROW ACCESS POLICIES

Answer 38

Lists the row access policies for which you have access privileges.

Question 39

SHOW SEQUENCES

Answer 39

Lists all the sequences for which you have access privileges.

Question 40

SHOW TABLES

Answer 40

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.

Question 41

SHOW VIEWS

Answer 41

Lists the views, including secure views, for which you have access privileges.

Question 42

TRUNCATE MATERIALIZED VIEW

Answer 42

Removes all rows from a materialized view, but leaves the view intact (including all privileges and constraints on the materialized view).

Question 43

UNDROP TABLE

Answer 43

Restores the most recent version of a dropped table.