4.6. Summary
In this chapter, we've covered the basics of the CREATE, ALTER, and DROP statements as they relate to creating a database and tables. There are, of course, many other renditions of these that we will cover as we continue through the book. We have also taken a look at the wide variety of options that we can use in databases and tables to have full control over our data. Finally, we have begun to see the many things that you can use the Management Studio for in order to simplify our lives, and make design and scripting simpler.
At this point, we're done reviewing how to lay out your tables. We'll spend the next few chapters reviewing many of the ancillary items that go along with our tables (such as constraints) as well as some more advanced query constructs. From there, we're ready to review normalization and other basic database design as well as move into more advanced design.
Get Professional SQL Server™ 2005 Programming 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.
