SQL Server Architecture
Logical Database Components
The data in a Microsoft® SQL Server™ 2000 database is organized into several different objects. These objects are what a user can see when they connect to the database.
In SQL Server 2000, these components are defined as objects:
Constraints | Tables |
Defaults | Triggers |
Indexes | User-defined data types |
Keys | User-defined functions |
Stored procedures | Views |