Databases How-to Topics
A database in Microsoft SQL Server 2005 is made up of a collection of tables that contain data and other objects that are defined to support the activities performed with the data. These objects include views, indexes, stored procedures, and triggers. Before you can create objects within the database, you must create the database and also understand how to change the settings and the configuration of the database. This includes tasks such as expanding or shrinking the database, or specifying the files that are used to create the database.
In This Section
- How to: Add Data or Log Files to a Database (SQL Server Management Studio)
- How to: Attach a Database (SQL Server Management Studio)
- How to: Change the Configuration Settings for a Database (SQL Server Management Studio)
- How to: Create a Database (SQL Server Management Studio)
- How to: Create User-Defined Data Types (SQL Server Management Studio)
- How to: Delete a Database (SQL Server Management Studio)
- How to: Delete Data or Log Files from a Database (SQL Server Management Studio)
- How to: Detach a Database (SQL Server Management Studio)
- How to: Display Data and Log Space Information for a Database (SQL Server Management Studio)
- How to: Generate a Script (SQL Server Management Studio)
- How to: Increase the Size of a Database (SQL Server Management Studio)
- How to: Move a Database Using Detach and Attach (Transact-SQL)
- How to: Rename a Database (SQL Server Management Studio)
- How to: Set a Database to Single-user Mode (SQL Server Management Studio)
- How to: Shrink a Database (SQL Server Management Studio)
- How to: Shrink a File (SQL Server Management Studio)
- How to: Start the Maintenance Plan Wizard (SQL Server Management Studio)
- How to: Upgrade a Database Using Detach and Attach (Transact-SQL)
- How to: View a Database (SQL Server Management Studio)
- How to: View or Change the Recovery Model of a Database (SQL Server Management Studio)
- How to: View a List of Databases on an Instance of SQL Server (SQL Server Management Studio)
- How to: View the Dependencies of a Table (SQL Server Management Studio)
- How to: View the Settings for a Database (SQL Server Management Studio)
See Also
Other Resources
Database Creation and Design How-to Topics