Murach's SQL Server 2005 for Developers
How to create and maintain databases and tables with SQL statements

Once a database is designed, this chapter shows how to implement the design using the SQL data definition language (DDL) statements. As an application programmer, you can use the DDL statements to create and modify the database objects that you need for testing.
Chapter 10 How to create and maintain databases and tables with SQL statements
An introduction to DDL 298
The SQL statements for data definition 298
Rules for coding object names 300
How to create databases, tables, and indexes 302
How to create a database 302
How to create a table 304
How to create an index 306
How to use constraints 308
An introduction to constraints 308
How to use check constraints 310
How to use foreign key contraints 312
How to change databases and tables 314
How to delete an index, table, or database 314
How to alter a table 316
The script used to create the AP database 318
How the script works 318
How the DDL statements work 318
Perspective 322
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.