Question

Create a database in visual basic using sql server and create two tables to process information from one table to the next

Answer 1

In this section, you'll create two tables, a primary key in each table, and a few rows of sample data. You'll also create a foreign key to specify how records in one table correspond to records in the other table.

Create the Customers table

1. In Server Explorer, expand the Data Connections node, and then expand the SampleDatabase.mdf node.

2. Open the shortcut menu for Tables, and then select Add New Table.

   The Table Designer opens and shows a grid with one default row, which represents a single column in the table that you're creating. By adding rows to the grid, you'll add columns in the table.

3. In the grid, add a row for each of the following entries:

Column name	Data type	Allow nulls
CustomerID	nchar(5)	False (cleared)
CompanyName	nvarchar(50)	False (cleared)
ContactName	nvarchar (50)	True (selected)
Phone	nvarchar (24)	True (selected)