Sommario
SQL: DDL, ICs, Updates and Views
SQL is More Than Just a Query Language
Creating Relations
Destroying and Altering Relations
Creating Indexes
Integrity Constraints (Review)
Primary and Candidate Keys (Review)
Foreign Keys (Review)
General Constraints
Constraints Over Multiple Relations
Inserting New Records
Deleting Records
Modifying Records
Enforcing Referential Integrity
Referential Integrity in SQL/92
Views
Queries on Views
Updates on Views
Updatable Views
Views and Security
GRANT and REVOKE of Privileges
Security to the Level of a Field!
Summary of SQL’s DDL
Summary (Contd.)
|