Custom attributes can be assigned to most objects in an ElevateDB configuration or database using the ATTRIBUTES clause. These attributes are simply stored as a block of text along with the object to which they are assigned, and can later be retrieved by querying the system information tables in ElevateDB. It is recommended that you use a structured text format such as XML or INI (key-value pairs) in order to allow for quick and easy reading of any structured data that you wish to store as custom attributes.

The following DDL statements allow you to define custom attributes for the associated object being created or altered:

CREATE DATABASE
ALTER DATABASE

CREATE STORE
ALTER STORE

CREATE USER
ALTER USER

CREATE ROLE
ALTER ROLE

CREATE JOB
ALTER JOB

CREATE TABLE
ALTER TABLE

CREATE VIEW
ALTER VIEW

CREATE FUNCTION
ALTER FUNCTION

CREATE PROCEDURE
ALTER PROCEDURE