Documentation

How do I manage tables in FeatureBase Cloud?

This page provides an overview of FeatureBase tables and links to guide you through creating, altering and dropping tables.

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.

Before you begin

Data modeling

You can duplicate your existing RDBMS data structures within FeatureBase.

But to get the best results, users should perform a data modeling process to:

  • determine the specific data they wish to query
  • take advantage of FeatureBase-specific data types and constraints
  • run queries on the data to test if the structure meets expectations

By performing Data Modeling, customers may further reduce their raw data footprint and flatten out tables in order to make queries even faster.

IMPORTANT: Perform data modeling before creating tables to avoid issues.

Table 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

Column data types and constraints

Naming standard

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

  • column names can be up to 64 characters in length

Manage tables

Manage tables with FeatureBase Cloud

Manage tables with SQL statements

Manage table columns

Manage table columns with FeatureBase Cloud

Manage table columns with the ALTER TABLE statement

Next step

Further information

Additional SQL statements are available for use:

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

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