O'Reilly logo

MCITP SQL Server 2005 Database Administration All-in-One exam Guide by Darril Gibson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required