Databases How-to Topics

A database in Microsoft SQL Server 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