Help Center/ GaussDB/ Developer Guide(Distributed_2.x)/ Working with Databases/ Creating and Managing Tables/ Creating a Table
Updated on 2024-10-14 GMT+08:00
View PDF
Share

Creating a Table

Background

A table is created in a database and can be saved in different databases. Tables under different schemas in a database can have the same name. Before creating a table, refer to Planning a Storage Model.

For details about how to design a table suitable for services, see Best Practices of Table Design.

Creating a Table

Run the following command to create a table: 
1
2
3
4
5
6
7
8
9
 
openGauss=# CREATE TABLE customer_t1
(
    c_customer_sk             integer,
    c_customer_id             char(5),
    c_first_name              char(6),
    c_last_name               char(8)
)
with (orientation = column,compression=middle)
distribute by hash (c_last_name);

If the following information is displayed, the table has been created:

1
 
 CREATE TABLE

c_customer_sk, c_customer_id, c_first_name, and c_last_name are the column names of the table. integer, char(5), char(6), and char(8) are column name types.