How do I create a table in FeatureBase Cloud?

A table is a database object that stores data from external sources.

FeatureBase tables are similar to those in traditional relational databases:

• tables with columns
• columns with data types and constraints.

The first column is automatically created on all tables and serves as the primary key.

Table of contents

• Before you begin
• Naming standards
• Step 1: view tables
• Step 2: create table
• Step 3: choose the primary key
• Next step
• Further information

You can also create a table using a SQL CREATE TABLE statement then create tables and add data.

Before you begin

• Set up a FeatureBase Cloud account

• Connect to FeatureBase Cloud

• Learn how to create a database
• Learn how to manage tables

Naming standards

FeatureBase identifiers (including object names such as databases, tables and columns) start with a lower-case alphabetic character and can include:

• lower-case alphabetic characters
• numbers 0-9

• dash - and underscore _ characters.

• table names can be up to 230 characters in length

Step 1: view tables

Step 2: create table

1. Click Create table.
2. Select the destination database.
3. Enter a table name and an optional description.

Step 3: choose the primary key

The table ID column (_id) is used as the table primary key and must uniquely represent a record in your table.

1. Select the ID type.
2. Click Create.

Next step

• Learn how to add columns to a table

Further information

• Create table API reference

---