1
Q
BEGIN
A
Begins a transaction in the current session.
2
Q
COMMIT
A
Commits an open transaction in the current session.
3
Q
ROLLBACK
A
Rolls back an open transaction in the current session.
4
Q
SHOW LOCKS
A
Lists all running transactions that have locks on resources.
5
Q
SHOW TRANSACTIONS
A
List all running transactions.
Snowflake
flashcards
Decks in class (12)
# Cards
-
SQL DDL Commands10
-
SQL Uncategorized5
-
SQL Account & Session DDK34
-
SQL Database Schema Share DDL20
-
SQL Data Loading Unloading DDL15
-
SQL Data Pipeline DDL10
-
SQL DML Commands12
-
SQL Table View Sequence DDL43
-
SQL Transactions5
-
SQL User Defined Functions External Functions Stored Procedures DDL13
-
SQL User Security DDL54
-
SQL Warehouse Resource Monitor DDL10
