Creating and Maintaining Databases
Table of contents
- Creating and Maintaining Databases Overview
-
Databases
- Parts of a Database
- Database Design Considerations
- Creating a Database
-
Modifying a Database
- Expanding a Database
- Shrinking a Database
- Adding and Deleting Data and Transaction Log Files
- Creating Filegroups
- Changing the Default Filegroup
- Setting Database Options
- Creating a Removable Database
- Attaching and Detaching a Database
- Renaming a Database
- Changing the Database Owner
- Transaction Termination for Changing Database States
- Viewing a Database
- Documenting and Scripting Databases
- Database Maintenance Plan Wizard
- Deleting a Database
-
Tables
- Designing Tables
-
Creating and Modifying a Table
- Modifying Column Properties
- Adding and Deleting Columns
- Creating and Modifying PRIMARY KEY Constraints
- Creating and Modifying FOREIGN KEY Constraints
- Creating and Modifying UNIQUE Constraints
- Creating and Modifying CHECK Constraints
- Creating and Modifying DEFAULT Definitions
- Creating and Modifying Identifier Columns
- Viewing a Table
- Deleting a Table
- Indexes
- Views
-
Stored Procedures
- Extended Stored Procedures
- Creating a Stored Procedure
- Executing a Stored Procedure
- Modifying and Renaming a Stored Procedure
- Recompiling a Stored Procedure
- Viewing a Stored Procedure
- Deleting a Stored Procedure
-
Enforcing Business Rules with Triggers
- Designing Triggers
-
Creating a Trigger
- Programming Triggers
- Using Triggers that Include ROLLBACK TRANSACTION
- Using the inserted and deleted Tables
- Multirow Considerations
- Conditional INSERT Trigger
- Specifying First and Last Triggers
- Using Nested Triggers
- Using INSTEAD OF Triggers
- Using text, ntext, and image Data in INSTEAD OF Triggers
- Activating Triggers with Implicit and Explicit Null Values
- Modifying and Renaming a Trigger
- Viewing a Trigger
- Deleting a Trigger
- User-Defined Functions
- Using Extended Properties on Database Objects
- Full-Text Indexes