How to create tables in SQL server 2005 ?

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

Nagarjun's blog: Creating a table in SQL server 2005

Image Source:

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)
Kata Mutiara Kata Kata Mutiara Kata Kata Lucu Kata Mutiara Makanan Sehat Resep Masakan Kata Motivasi obat perangsang wanita