About maintaining tables and other SQL schema elements

You can maintain tables and other SQL schema elements from the application. Among other things, you can:

Create SQL tables
Add, delete, or modify columns on tables
Define one or more primary keys or other constraints
Update existing SQL tables
Edit SQL user-defined data types

Note: Building IDOs over tables in schemas other than dbo is not currently supported.

System administrators can use the Metadata Access Controls form to restrict access to application metadata and prevent users from altering core SQL tables. You cannot modify SQL tables that are set to Locked in the Metadata Access Controls form. You can view SQL tables that are set to Read Only but you cannot modify them. You can view and modify SQL tables that are set to Unlocked.