Home

The Tables of a Database

 

Tables Fundamentals

 

Introduction

As we saw when studying data sets, a table is one or more lists of items. If the table is only one list of items, these items are identical in nature. Here is an example:

Judie
Ernest
Bill
David
Hermine

If the table is made of more than one list, each list is made in a distinguishable category. 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 LearningPractical Learning: Introducing Database Tables

  1. Start Microsoft Visual C#
  2. If the Server Explorer is not visible, on the main menu, click View -> Server Explorer.
    In the Server Explorer, right-click Data Connections and click Create New SQL Server Database
  3. In the Server Name combo box, select the server or type (local)
  4. Accept or specify your authentication mode
  5. Set the name of the database to CPAR1 and click OK

Visual Creation of a Table

The information of a table is organized in categories called columns. To visually create a table in Microsoft SQL Server, first open the SQL Server Management Studio. In the Object Explorer, locate and expand the database for which you are creating the table. Then right-click the Tables node and click New Table. A window would come up and wait for you to proceed:

Table

To visually create a table in Microsoft Visual Studio, in the Server Explorer, expand the connection to the database that will own the table. Right-click the Tables node and click Add New Table:

Add New Table

After clicking Add New Table, a new empty table would come up and expect you to take charge:

New Table

Practical LearningPractical Learning: Starting a Table

  1. In the Server Explorer, expand server.CPARr1.dbo
  2. Under it, right-click Tables and click Add New Table

Tables Names

To complete the creation of a table, you must save it. If you are freshly creating a table and decide to save it, you would be prompted to name it. The name of a table:

  • Can be made of digits only. For example you can have a table named 148
  • Can start with a digit, a letter, or an underscore
  • Can be made of letters, digits, and spaces

Besides these rules, you can make up yours. To avoid confusion, here are the rules we will use to name our tables:

  • A name will start with a letter. Examples are act or Second
  • After the first character, the name will have combinations of underscores, letters, and digits. Examples are _n24, act_52_t
  • Unless stated otherwise, a name will not include special characters such as !, @, #, $, %, ^, &, or *
  • If the name is a combination of words, each word will start in uppercase. Examples are Staff Members or Video Titles

Creating a Table With SQL

 

Introduction

In SQL, to create a table, you start with the following statement:

CREATE TABLE TableName;

The CREATE TABLE expression is required. The TableName factor specifies the name of the new table. The TableName can use the rules and suggestions we reviewed for the tables.

Using Sample Code

To assist you with creating a table, Microsoft SQL Server can generate sample code for you. You can then simply modify or customize it. In Microsoft SQL Server Management Studio, first display or open an empty query window. To display the Templates Explorer, on the main menu, you can click View -> Templates Explorer. In the Templates Explorer, expand the Table node. Under table, drag Create Table and drop it in the query window. Sample code would be generated for you.

 

Published on Monday 28 December 2007

 

Home Copyright © 2007 FunctionX, Inc. Next