Data Definition# Table Basics Creating Tables Deleting Tables Default Values Generated Columns Rules Constraints 1. Check Constraints 2. Not-Null Constraints 3. Unique Constraints 4. Primary Keys 5. Foreign Keys 6. Exclusion Constraints System Columns Modifying tables 1. Adding a Column 2. Removing a Column 3. Adding a Constraint 4. Removing a Constraint 5. Changing a Column’s Default Value 6. Changing a Column’s Data Type 7. Renaming a Column 8. Renaming a Table Privileges Demo Access Control List (ACL) Privilege Abbreviations Summary of Access Privileges Schemas Creating a Schema Deleting a Schema The Schema Search Path Privileges The System Catalog Schema Usage Patterns