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.
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.
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|
|String||String key or a combination of columns used to create a unique key|
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 with FeatureBase Cloud
Manage tables with SQL statements
Manage table columns with FeatureBase Cloud
Manage table columns with the ALTER TABLE statement
Additional SQL statements are available for use:
© 2022 Molecula Corp. (DBA FeatureBase). All rights reserved.