Summary
This chapter covers the basic tools you can use to ensure the integrity of the data in a database. The integrity of data is directly related to its value; remember the concept of “garbage in, garbage out.” If you take the time to implement the constraints and other methods discussed in this chapter, you provide a solid foundation for the storage of data and avoid the headaches related to dealing with “garbage” data.
Chapter 24, “Creating and Managing Views,” discusses a means for virtually accessing the data in tables. Virtual tables, or views, allow you to selectively choose the data elements on one or more tables that you want to present as a single window into your data.
Get Microsoft SQL Server 2014 Unleashed 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.
