Database Applications (Schemas)

Application

A database application in 602SQL can be into the following:

Back-end objects - These objects compose the data basis of the application (database tables, domains, triggers, queries, stored procedures and sequences). The definition of these objects only contain SQL language. Roles are also considered back-end objects.
Auxiliary objects - Data transfers, XML data transfers and diagrams exist outside of the SQL language.

The schema concept is used for the same set of objects in SQL language.

Application Name and ID

An application name has to fulfill the rules for an identifier (i.e. maximum number of characters is 31) and mustn't contain a dot ("."). An application has a unique binary identification (UUID). Function Current_application, Local_schema_name or Schema_uuid serves for getting names or UUID. Application UUID is used in some system queries.

Creating and Deleting

Applications are created and deleted in the Control Panel of the 602SQL Client. There are also SQL statements CREATE SCHEMA and DROP SCHEMA.

An application may be exported and then imported to another SQL Server.

List of topics:

Auxiliary Windows in the Ddebug Mode

602SQL Development and Management Client

Database Objects Designers