Microsoft SharePoint Team Blog
The official blog of the Microsoft SharePoint Product Group

The Tables of a Database


Tables Fundamentals


Introduction


A table is primarily a list of items or a group of lists. To manage such a list, it should be meticulously organized. To organize this information, it is divided in sections. Here is an example:

Name Age Gender Relationship
Judie 18 Female Sister
Ernest 24 Male Cousin
Bill 52 Unknown Uncle
David 36 Male Brother
Hermine 12 Unknown Niece

Based on this, a list is simply an arrangement of information and this information, also called data, is stored in tables.

Practical Learning: Starting a Database



Start Microsoft SQL Server, connect and, in the Object Explorer, expand the Databases node
In the Object Explorer, right-click Databases and click New Database...
In the New Database dialog box, set the Database Name to BCR
Under Initial Size (MB) column, set the size of the PRIMARY filegroup to 10
Click OK
Visual Creation of a Table



The information of a table is organized in categories called columns and horizontal arrangements called records or rows. A column holds a category of data that is common to all records. A table must have at least one column. This means that you cannot create a table without defining at least one column.

Practical Learning: Creating a Table



In the Object Explorer, expand the BCR node (click its + button)
Under BCR, right-click Tables and click New Table...






source : http://blogs.msdn.com/sharepoint/default.aspx