ALTER DATABASE

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

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Under Construction

Purpose

Used to add or modify database metadata

Syntax

ALTER DATABASE [<database>!]<table> 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 add or modify 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'