ALTER DATABASE

From Lianjapedia
Revision as of 06:30, 24 February 2017 by Yvonne.milne (Talk | contribs)

Jump to: navigation, search

Under Construction

Purpose

Used to define database metadata

Syntax

ALTER DATABASE <database> METADATA <cMetaData>

See Also

ADD TABLE, ALTER INDEX, ALTER TABLE, ALTER VIRTUALTABLE, COLUMNMETADATA(), CONSTRAINTS, CREATE DATABASE, CREATE INDEX, CREATE TABLE, CREATE TRIGGER, CREATE VIRTUALTABLE, DATA TYPES, DATABASEMETADATA(), DELETE TRIGGER, DROP DATABASE, DROP INDEX, DROP TABLE, GETENV(), INSERT, METADATA_DECODE(), METADATA_ENCODE(), METADATA_FINDTYPE(), OPEN DATABASE, SELECT, TABLEMETADATA(), TABLEMETADATAVERSION()

Description

The ALTER DATABASE command is used to define database metadata.

Example

alter database southwind;
metadata "customer=Lianja Inc.;contact=sales@lianja.com"
open database southwind
? databaseMetaData() // --> 'customer=Lianja Inc.;contact=sales@lianja.com'