How to Create Tables in your SQL Server Database

Now that you have created the database itself, you need to create at least one table to go in it.

To create a table, right click on the database in the Solution Explorer. From the menu that appears, select Open:

Open a database from the Solution Explorer

When you click Open, you'll see the Database Explorer appear on the left hand side of your screen (it's called Server Explorer in Visual Studio Community 2015)::

The Database Explorer in Visual Studio

(If you have Visual Studio Express 2012/2013 then all the items in the image above may not appear.)

To create a new table, right click on Tables. From the menu that appears, select Add New Table:

The Add New Table menu

When you click on Add New Table you should see the table designer open up in the centre of your screen. We'll now create a new table in the database. To see how to do that click below, right.