O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating, Modifying, and Dropping Tables

When you create a table, you must specify the table name, column names, and column data types. Column names must be unique to a table, but the same column name can be used in different tables within the same database. The column name can be omitted for columns that are created with a timestamp data type, in which case the column name will default to "timestamp."

Creating Tables

You should adopt standards when naming your tables and columns. Making good use of uppercase and lowercase letters and using underscores to separate words will help make the table and columns easier to read and understand. Try to keep the names short but still long enough to be descriptive. If you use the same column in different tables, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required