After the creation of the database the next work is to create/design tables in SQL server 2005 as per our requirement. To the best of my knowledge in SQL server 2005 or even in any version of Microsoft SQL Server, the tables can be created in at least three best ways (a) Direct method (Manually) (b) Query Method (c) Studio.NET 2005
Image Source: sites.google.com/site/webnadu/SQL_server_new_table_creation.jpg
But my favorite methods is:
Direct Method
- Expand Microsoft SQL server 2005 database folder.
- And then expand your database folder.
- Now right click on the Tables folder and click on the New Table option.
- Now design your database structure as per your requirement (Just as we do in Microsoft Access)