Creating Database Tables

Now that we have created a database, we're ready to create our first database table. Recall that database tables are two-dimensional grids, with the columns specifying the attributes of the data stored in the table, the rows of the table specifying the data. Additionally, tables have names that uniquely identify them.

When creating a new database table, we do not specify any of the data. Rather, we name the table as well as specify its structure—the name and type of each of the table's columns.

Creating database tables through the Web Matrix Project is quite easy. Just proceed as follows:

1.
Start by clicking the Tables icon in the Data tab.
2.
Next click the New Item icon, which is the second icon in the Data tab (the ...

Get SAMS Teach Yourself ASP.NET in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.