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 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.
