Common SQL Server Objects

SQL Server uses the term object to describe a database component. Common database objects include tables, rules, defaults, user-defined data types, views, triggers, and stored procedures.


Do not be mislead by the term object. SQL Server is not an object-oriented database.


A table is used to store data. It is organized in a row/column manner (see Figure 2.15). You can retrieve, modify, and remove data from a table by using the SQL language.

Figure 2.15. An example of a table.


A rule is used to enforce a data constraint (see Figure 2.16). Rules are column specific and cannot perform table lookups. Generally, ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.