Database Objects ​

Yellowbrick supports the following database objects and commands to create and modify them:

• Physical databases
• Schemas
• Tables (persistent and temporary)
• Views
• Roles (roles and users are equivalent objects)
• Prepared statements
• Stored procedures
• Cursors
• Sequences

DML Commands ​

Yellowbrick supports several DML commands:

• INSERT
• UPDATE
• DELETE
• TRUNCATE

Transactions ​

Yellowbrick supports the following commands for working with transactions:

• BEGIN/START
• END/COMMIT
• ABORT/ROLLBACK
• SAVEPOINT
• RELEASE SAVEPOINT
• ROLLBACK TO SAVEPOINT

Not Supported ​

Yellowbrick does not support the following database objects:

• Collations
• Domains
• Indexes
• Tablespaces
• Triggers
• User-defined functions (UDFs)
• User-defined types

Parent topic:Database Administration