Summary

Tables are the basis of a relational database. In this chapter, we have learned how to create, modify, and delete tables. We have explored the different system data types provided by SQL Server 2005, along with how to create user-defined data types. We described how to define tables including the use of NULL values and the IDENTITY property.

Views are virtual tables that look and act like database tables to the end user. Views can be used to limit both the columns and the rows to provide a simplified view for the end user, to simplify coding for the database developer, and to increase data security. In this chapter we have learned how to create, modify, and delete views. We have also learned about indexed views. A clustered index is created ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.