Application Programming Interface Guide > DSL API > Virtual Databases > Considerations
 
Considerations
Listed below are some points to consider while working with Virtual Databases:
During creation of virtual database, the adapter name used is "COMPOSITE_DATABASE".
The DATASOURCE_TYPE of a virtual database is "VirtualRelational".
Use the "CREATE VIRTUAL DATABASE IF NOT EXISTS" syntax to avoid any duplicate error messages.
For annotation QUOTED_STRING, an explicit NULL keyword or a quoted string 'NULL' can be specified. This is to allow annotation to be unset or set to null explicitly.
The virtual databases are created in the "/services/databases" area.
Altering a virtual database can alter the annotation or rename the virtual database. Use the "RENAME AS" syntax to rename a published database.
IF EXISTS" syntax in DROP to avoid any error messages, in case the resource is not found.