MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444)

APPENDIX F SQL Database Design Object Summary

This appendix has an abbreviated listing of many database objects. It includes

• Constraints

• Views

• Functions

• Stored procedures

• Triggers

• CLR integrated objects

• Indexes and indexed views

The mind is not a vessel to be filled, but a fire to be ignited. —Plutarch

In early chapters of this book, we covered some basic database design objects such as constraints and views. Later we introduced some advanced database objects such as user-defined functions, stored procedures, and triggers. When we talked about optimizing databases, we brought indexes into the mix.

All of the objects work together to produce a cohesive database solution. One of your goals as a DBA is to understand what the available ...