Sybase 12.4.2 manual 119

CHAPTER 3 Working with Database Objects

SQL statement for creating tables

Example

2Click the Tables folder for that database.

3Double-click Add Table in the right panel.

4Enter a Name for the table.

5To create an IQ table, skip this step. To create a table in the Catalog Store, double-click the Advanced Table Properties icon, and select SYSTEM from the DB space dropdown list.

6Enter the columns you want and their data types and other attributes in the Table Editor.

7Click OK to create the table.

The SQL statement for creating tables is CREATE TABLE.

This section describes how to use the CREATE TABLE statement. The examples in this section use the sample database. To try the examples, run DBISQL and connect to the sample database with user ID DBA and password SQL.

For information on connecting to the sample database from DBISQL, see “Connecting to a database from DBISQL”.

You can create tables with other tools in addition to DBISQL. The SQL statements described here are independent of the tool you are using.

The following statement creates a new, permanent IQ table to describe qualifications of employees within a company. The table has columns to hold an identifying number, a name, and a type (say technical or administrative) for each skill.

CREATE TABLE skill ( skill_id INTEGER NOT NULL, skill_name CHAR( 20 ) NOT NULL, skill_type CHAR( 20 ) NOT NULL

)

You can execute this command by typing it into the DBISQL command window, and pressing the execute key (F9).

•Each column has a data type. The skill_id is an integer (like 101), the skill_name is a fixed-width CHARACTER string containing up to 20 characters, and so on.

•The phrase NOT NULL after their data types indicates that all columns in this example must contain a value.

•In general, you would not create a table that has no primary key. To create a primary key, see “Creating primary and foreign keys” on page 125.

119