Murach's SQL Server 2008 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 developer, 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 322
The SQL statements for data definition 322
Rules for coding object names 324
How to create databases, tables, and indexes 326
How to create a database 326
How to create a table 328
How to create an index 330
How to use constraints 332
An introduction to constraints 332
How to use check constraints 334
How to use foreign key contraints 336
How to change databases and tables 338
How to delete an index, table, or database 338
How to alter a table 340
The script used to create the AP database 342
How the script works 342
How the DDL statements work 342
t


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

Murach's SQL Server 2008

Learn more about this book

View the table of contents


More about the eBook



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.