Skip to main content Link Menu Expand (external link) Document Search Copy Copied

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

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: create table

  • Click Create table.
  • Select the destination database.
  • Enter a table name and an optional description.

Step 2: choose the primary key

The _id column in each table represents the primary key and supports two data types:

Data type Description Example Advantage Disadvantage
ID data type One or more contiguous blocks of positive integers 7,8,9,10,11,12,...20,21,22,23,... Faster queries Warning: performance and storage are adversely affected if values are non-contiguous
String data type String literal values can be supplied in any order if used as primary key “a23”, “s93kk”, “h82k”, “2023-02-10”,… Automatically mapped to blocks of contiguous integers Higher storage and performance costs

Select Number to choose the ID data type

Step 3: Create the table

  • Click Create.

Next step

Further information