Database Reference
In-Depth Information
• DELETE
• TRUNCATE
• REFERENCES
• TRIGGER
• CREATE
• CONNECT
• TEMPORARY
• EXECUTE
• USAGE
There are different privileges associated with different objects. For instance, the
EXECUTE
privilege is associated with procedure. The
GRANT
command is used to
grant any privilege to any user. Similarly, to take back privileges, the
REVOKE
command is used.
Summary
In this chapter, we learned how to utilize the SQL language for a collection of
everyday
Database Management System
(
DBMS
) exercises in an easy-to-use
practical way. We igured out how to make a complete
warehouse_db
database that
incorporates DDL (create, alter, and truncate) and DML (insert, update, and delete)
operators, all types of data types, and constraints. The knowledge learned in this
chapter will allow you to easily manipulate data across different tables and help you
successfully design a database.
In the next chapter, you will learn about the procedural languages in more detail.