Difference between revisions of "ALTER DATABASE"

From Lianjapedia
Jump to: navigation, search
(Created page with "''Under Construction'' ==Purpose== Used to add or modify database metadata ==Syntax== ALTER DATABASE [<database>!]<table> METADATA <cMetaData> ==See Also== ADD...")
 
Line 1: Line 1:
 
''Under Construction''
 
''Under Construction''
 
==Purpose==
 
==Purpose==
Used to add or modify database metadata  
+
Used to define database metadata  
  
 
==Syntax==
 
==Syntax==
ALTER DATABASE [<database>!]&#060;table&#062; METADATA <cMetaData>
+
ALTER DATABASE <database> METADATA <cMetaData>
  
 
==See Also==
 
==See Also==
Line 10: Line 10:
  
 
==Description==
 
==Description==
The ALTER DATABASE command is used to add or modify database metadata.
+
The ALTER DATABASE command is used to define database metadata.
  
 
==Example==
 
==Example==

Revision as of 06:30, 24 February 2017

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'