SQL Database Schema Share DDL Flashcards
ALTER DATABASE
Modifies the properties for an existing database.
ALTER SCHEMA
Modifies the properties for an existing schema, including renaming the schema or swapping it with another schema, and changing the Time Travel data retention period (if you are using Snowflake Enterprise Edition or higher).
ALTER SHARE
Modifies the properties for an existingshare.
CREATE DATABASE
Creates a new database in the system.
CREATE SCHEMA
Creates a new schema in the current database.
CREATE SHARE
Creates a new,emptyshare.
DESCRIBE DATABASE
Describes the database.
DESCRIBE SCHEMA
Describes the schema.
DESCRIBE SHARE
Describes the data objects that are included in ashare.
DROP DATABASE
Removes a database from the system.
DROP SCHEMA
Removes a schema from the current/specified database.
DROP SHARE
Removes the specifiedsharefrom the system and immediately revokes access for all consumers (i.e. accounts who have created a database from the share).
SHOW DATABASES
Lists the databases for which you have access privileges across your entire account, including dropped databases that are still within the Time Travel retention period and, therefore, can be undropped.
SHOW SCHEMAS
Lists the schemas for which you have access privileges, including dropped schemas that are still within the Time Travel retention period and, therefore, can be undropped.
SHOW SHARES
Lists allsharesavailable in the system.