About maintaining tables and other SQL schema elements

You can maintain tables and other SQL schema elements from within your Mongoose-based application. Among other things, you can do these things:

  • 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: We do not currently support the building of IDOs over tables in schemas other than dbo at this time.

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 only SQL tables that are set to Unlocked on that form.