Cinchy Platform Documentation
Search…
Cinchy v5.0.0
Dataware Overview
Other Wiki Spaces
Cinchy Data Sync
Cinchy Meta Forms
Cinchy Meta Reports
Cinchy Query Language
Angular SDK
JavaScript SQK
Release Notes
Release Notes
Frequently Asked Questions
Deployment Guide
Deployment Installation Guides
Upgrade Guides
Guides for Using Cinchy
User Guides
Builder Guides
Best Practices
Creating Tables
Columns
System Tables
Attaching Files
Linking Data
Formatting Rules
Indexing and Partitioning
Data Controls
Saved Queries
Building Forms
CinchyDXD Utility
Multi-Lingual Support
Integration Guides
Administrator Guide
Additional Guides
API Guide
API Overview
Powered By
GitBook
System Tables
System tables are included out-of-the-box with your Cinchy platform, and can be used to track and manage a variety of data.
Some examples of system tables
You can easily query for a list of your system tables using the below:
SELECT
[
Name
]
FROM
[
Cinchy
].[
Tables
]
WHERE
[
Deleted
]
IS
NULL
AND
[
Domain
]
=
'Cinchy'
The system tables included are:
Applets:
This system table manages a list of all your integrated applications
Data Experience Definitions:
This is a system table for managing data experience definitions
Data Experience References:
This is a system table for managing reference data for data experiences
Data Experience Release Artifacts:
This is a system table for maintaining data experience release artifacts
Data Experience Releases:
This is a system table for maintaining data experience releases
Data Security Classifications:
This is a system table for maintaining data security classifications
Data Sync Configurations:
This system table manages a list of all your data sync configurations.
Domains:
This system table manages a list of all the domains in your instance.
Execution Log:
This system table tracks the execution logs of data syncs
Formatting Rules:
This system table manages your formatting rules
Groups:
System table for managing all groups
Literal Groups:
This system table maintains a list of groups
Literal Translations:
This system table maintains a list of literal translations
Literals:
This system table maintains a list of literals
Regions:
This system table maintains a list of regions
Saved Queries:
This system table manages a list of all user saved queries that can be exposed via the REST API
System Colours:
System table for maintaining colours
Table Access Control:
This system table maintains a list of all table access controls in your instance
Table Columns:
This system table manages a list of all the system column definitions
Tables:
This system table manages a list of all the tables in your instance.
User Defined Functions:
This system table manages a list of all your user defined functions
Users:
System table for managing all user information including enabling/disabling the ability to create tables, queries, etc.
Views:
This system table manages a list of all the views in your instance.
​
Previous
Columns
Next
Attaching Files
Last modified
3mo ago
Copy link