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.



    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features