SQL DDL Commands

Question 1

ALTER<object></object>

Answer 1

Modifies the metadata of an account-level or database object, or the parameters for a session.

Question 2

ALTER INTEGRATION

Answer 2

Modifies the properties for an existing integration.

Question 3

COMMENT

Answer 3

Adds a comment or overwrites an existing comment for an existing object.

Question 4

CREATE<object></object>

Answer 4

Creates a new object of the specified type.

Question 5

CREATE INTEGRATION

Answer 5

Creates a new integration in the system or replaces an existing integration.

Question 6

DESCRIBE<object></object>

Answer 6

Describes the details for the specified object.

Question 7

DROP<object></object>

Answer 7

Removes the specified object from the system.

Question 8

SHOW<object></object>

Answer 8

Lists the existing objects for the specified object type.

Question 9

UNDROP<object></object>

Answer 9

Restores the specified object to the system.

Question 10

USE<object></object>

Answer 10

Specifies the role, warehouse, database, or schema to use for the current session.