Home and Learn: C# NET Course

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 Server Explorer appear on the left-hand side of your screen:

The Database Explorer in Visual Studio

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 configure this new database table using the designer. To see how to do that click below, right.

back to the c# net contents page


Buy the Book of this Course

Email us: enquiry at homeandlearn.co.uk