Documentation

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.

NOTE: You can also use a SQL-Preview Create Table statement

Before you begin

Naming standards

FeatureBase object names must start with an alphabetic character, and 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

  • Click Databases then the database that contains the table.
  • Click Tables if it is not already selected.

Step 2 - create table

  • Click Create table.
  • Select the destination database.
  • 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.

Type Data source table unique key
Number Positive integer
String String key or a combination of columns used to create a unique key
  • Select the ID type.
  • Click Create.

Next step

Something missing or incorrect?
Help improve this article or join us on Discord!

© 2022 Molecula Corp. (DBA FeatureBase). All rights reserved.