Creating Tables

Tables can be created in SQL Server using a graphical interface or the T-SQL language. The graphical interface can be faster for complex tables, but it does not offer the flexibility of T-SQL. T-SQL is more flexible, but it does not offer the simplicity of the graphical interface. You must choose between the two methods for each table you create. When you're creating simple tables (tables containing two to five columns with no special constraint requirements), you may find it convenient to usually use T-SQL. When the table is more complicated, you may want to use the Table Designer and then export the table to a script file so that you have the T-SQL code for documentation. In general, if the table is very small, you will be more ...

Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.