Murach's SQL Server 2005 for Developers
How to use the Management Studio for
database design

Once you know how to use DDL statements, this chapter shows you how to use the Management Studio to generate this code for you. The Management Studio makes it easy to perform common tasks, and you'll use it frequently to create, modify, and delete the objects of a database.
Chapter 11 How to use the Management Studio for database design
How to work with a database 324
How to create a database 324
How to delete a database 324
How to work with tables 326
How to create, modify, or delete a table 326
How to work with foriegn key relationships 328
How to work with indexes and keys 330
How to work with check constraints 332
How to examine table dependencies 334
How to generate scripts 336
How to generate scripts for databases and tables 336
How to generate a change script when you modify a table 338
Perspective 340
t


© Copyright 1998-2008 Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2005

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.