SQL Database Language

  1. Database Structure Management
    1. Database Operations
      1. Creating Databases
        1. CREATE DATABASE Syntax
          1. Database Naming Conventions
            1. Character Set Specification
              1. Collation Settings
              2. Modifying Databases
                1. ALTER DATABASE Options
                  1. Character Set Changes
                    1. Collation Modifications
                    2. Dropping Databases
                      1. DROP DATABASE Syntax
                        1. Data Loss Warnings
                          1. Dependency Considerations
                        2. Table Creation and Management
                          1. CREATE TABLE Fundamentals
                            1. Table Naming Conventions
                              1. Column Definitions
                                1. Data Type Specifications
                                2. Column Properties
                                  1. NULL and NOT NULL
                                    1. Default Values
                                      1. Auto-Increment Columns
                                        1. Computed Columns
                                        2. Table Modification
                                          1. ALTER TABLE Operations
                                            1. Adding Columns
                                              1. Column Position
                                                1. Default Value Handling
                                                2. Dropping Columns
                                                  1. Data Loss Implications
                                                    1. Dependency Checks
                                                    2. Modifying Columns
                                                      1. Data Type Changes
                                                        1. Size Modifications
                                                          1. Constraint Changes
                                                          2. Renaming Elements
                                                            1. Column Renaming
                                                              1. Table Renaming
                                                            2. Table Removal
                                                              1. DROP TABLE Syntax
                                                                1. Cascade Options
                                                                  1. Dependency Resolution
                                                                2. Constraints Implementation
                                                                  1. Constraint Types Overview
                                                                    1. NOT NULL Constraints
                                                                      1. Column-Level Definition
                                                                        1. Data Validation
                                                                          1. Modification Rules
                                                                          2. UNIQUE Constraints
                                                                            1. Single Column Uniqueness
                                                                              1. Multi-Column Uniqueness
                                                                                1. Index Creation
                                                                                2. PRIMARY KEY Constraints
                                                                                  1. Single Column Primary Keys
                                                                                    1. Composite Primary Keys
                                                                                      1. Uniqueness and Non-NULL
                                                                                        1. Index Implications
                                                                                        2. FOREIGN KEY Constraints
                                                                                          1. Reference Table Specification
                                                                                            1. Referential Integrity Rules
                                                                                              1. CASCADE Options
                                                                                                1. ON DELETE CASCADE
                                                                                                  1. ON UPDATE CASCADE
                                                                                                    1. ON DELETE SET NULL
                                                                                                      1. ON UPDATE SET NULL
                                                                                                      2. Self-Referencing Foreign Keys
                                                                                                      3. CHECK Constraints
                                                                                                        1. Condition Specification
                                                                                                          1. Data Validation Rules
                                                                                                            1. Complex Conditions
                                                                                                            2. DEFAULT Constraints
                                                                                                              1. Default Value Assignment
                                                                                                                1. Expression-Based Defaults
                                                                                                                  1. System Function Defaults
                                                                                                                  2. Constraint Management
                                                                                                                    1. Adding Constraints to Existing Tables
                                                                                                                      1. Dropping Constraints
                                                                                                                        1. Disabling and Enabling Constraints
                                                                                                                          1. Constraint Naming Strategies

                                                                                                                      Previous

                                                                                                                      4. Data Manipulation Operations

                                                                                                                      Go to top

                                                                                                                      Next

                                                                                                                      6. Multi-Table Operations and Joins