|
When a database is first created, the only tables in the database are the system tables, which hold the database schema. You can create new tables to hold your actual data, either with SQL statements in Interactive SQL or with Sybase Central.
There are two types of tables that you can create:
Base table A table that holds persistent data. The table and its data continue to exist until you explicitly delete the data or drop the table. It is called a base table to distinguish it from temporary tables and views.
Temporary table Data in a temporary table is held for a single connection only. Global temporary table definitions (but not data) are kept in the database until dropped. Local temporary table definitions and data exist for the duration of a single connection only. For more information about temporary tables, see Working with temporary tables.
Tables consist of rows and columns. Each column carries a particular kind of information, such as a phone number or a name, while each row specifies a particular entry.
Connect to a database.
Open the Tables folder.
From the File menu, choose New > Table.
The Create Table wizard appears.
Follow the instructions in the wizard.
The new table appears in the Table folder.
On the Columns tab in the right pane, you can add columns to the table.
Choose File > Save when finished.
Connect to the database as a DBA user.
Execute a CREATE TABLE statement.
The following statement creates a new table to describe qualifications of employees within a company. The table has columns to hold an identifying number, a name, and a type (technical or administrative) for each skill.
CREATE TABLE Skills ( SkillID INTEGER NOT NULL, SkillName CHAR( 20 ) NOT NULL, SkillType CHAR( 20 ) NOT NULL );
For more information, see CREATE TABLE statement.