Create a table
Navicat provides two ways to create a table. You can create a new (empty) table from scratch, or you can create a new (empty) table using an existing table in the database.
Create a new table from scratch
Create a new table from an existing one in the database

Create a new table from scratch
You can use these steps to guide you through creating a table from start to finish. You'll use many of these steps in creating every table. The others you'll use when you design a table to contain a particular type of data or define how a field appears. You need to use only the steps that are relevant to the type of data or field definitions specific to the table that you're creating.

1. Create a table
   Create a table from scratch using the Table Designer
2. Add fields to the table that contain data
   Create a field for text or memos
   Create a field for numbers or currency
   Create a field for dates or times
   Create a field for sets and enumerates
3. Define how a field appears or handles data
   Define the number of decimal places in a field
   Define a default value for a field
4. Create a primary key to uniquely identify records
   Set or change the primary key
5. Create an index to find and sort records faster
   Create a single-field index
   Create a multiple-field index
6. Make final adjustments
   Change a field name in table
   Delete a field from a table
   

Create a new table from an existing one in the database

1. If you are not in the Database Window where you want to create the table, click on the database in the Server Navigator
2. Click the Table tab
3. Click the Design Table button at the Database Window
   OR
   select the table and click Design Table in the table menu
4. In the Table Design Window , make all the modifications to the fields and indexes that you require and click Save As from the toolbar
5. Enter the name of the new table and press OK

Open a table

1. In the Database Window , click the Table tab
2. Select the table that you want to open in the Database Window
3. To open the table in Data View, double click the table or click Open Table in the Database Window
4. To open the table in Design View, click Design Table in the Database Window

Open a table with images

1. In the Database Window , click the Table tab
2. Select the table that you want to open in the Database Window
3. To open the table in Data View, control click the table and select Open Table (Quick) in the Database Window (Note: Faster performance for opening the table as BLOB fields will not be loaded until you click on the field using this opion.)
4. To open the table in Design View, click Design Table in the Database Window

Design a table

1. In the Database Window , click the Table tab
2. Select the table that you want to design in the Database Window
3. Click Design Table in the Database Window

Empty a table

1. In the Database Window , click the Table tab
2. Control-click on the table that you want to empty in the Database Window
3. Select Empty Table in the pop-up menu

Truncate a table

1. In the Database Window , click the Table tab
2. Control-click on the table that you want to empty together with resetting the auto-increment value in the Database Window
3. Select Truncate Table in the pop-up menu

Duplicate a table

1. In the Database Window , click the Table tab
2. To copy structure and data, you can Control-click on the table and select Duplicate Table in the pop-up menu.
3. To copy structure only, choose [Structure only]. To copy structure and data, choose [Structure and Data].

Copy tables

1. Drag the chosen tables to the target database.
   
2. Select one of the following options:
   - Structure only - Copy table structure only.
   - Structure and Data - Copy table structure including data.

Note: Tables being dragged to the database within the same connection will be copied directly, otherwise Data Transfer will pop up.

Set or change the table type

1. Open the table in Design View
2. Select the Options tab
3. Select the table type from the Table Type combo box
4. Select Save or Save As from the File menu when you are ready to save the table
   
   New: solidDB type support from Navicat 6.3.5 or later

Maintain a table
Please visit Maintaining your Database/Tables for details

Filter Wizard
Please visit Filter Wizard for details