Summary

Tables are the key to the Relational Database System. Careful attention must be paid when creating tables to choose the proper datatypes to ensure efficient storage of data, to add appropriate constraints to maintain data integrity, and to script the creation and modification of tables to ensure that they can be re-created if necessary.

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.