Difference between revisions of "ALTER DATABASE"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
==Purpose== | ==Purpose== | ||
Used to define database metadata | Used to define database metadata | ||
==Syntax== | ==Syntax== | ||
| − | ALTER DATABASE < | + | ALTER DATABASE <cDatabase> METADATA <cMetaData> |
==See Also== | ==See Also== | ||
| Line 10: | Line 9: | ||
==Description== | ==Description== | ||
| − | The ALTER DATABASE command is used to define database metadata. | + | The ALTER DATABASE command is used to define database metadata for the database <cDatabase>. The metadata to be applied to the database is specified in the <cMetaData> character string. For use with the MetaData Editor in the Data workspace, the <cMetaData> string should be in the format: |
| + | |||
| + | <pre>"name1=value;name2=value"</pre> | ||
| + | |||
| + | without internal quotes. | ||
| + | |||
| + | Alternatively, <cMetaData> can be a JSON string, in which case it is not modifiable or viewable in the MetaData Editor. | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | alter database southwind | + | // Name value pairs for use with the MetaData Editor |
| − | metadata "customer=Lianja Inc.;contact=sales@lianja.com" | + | alter database southwind metadata "customer=Lianja Inc.;contact=sales@lianja.com" |
open database southwind | open database southwind | ||
? databaseMetaData() // --> 'customer=Lianja Inc.;contact=sales@lianja.com' | ? databaseMetaData() // --> 'customer=Lianja Inc.;contact=sales@lianja.com' | ||
| + | |||
| + | // JSON string | ||
| + | alter database sw2 metadata '{"purpose":"Documentation Test Database","owner":"Yvonne Milne"}' | ||
| + | open database sw2 | ||
| + | ? databasemetadata() // --> '{"purpose":"Documentation Test Database","owner":"Yvonne Milne"}' | ||
</code> | </code> | ||
Revision as of 11:32, 24 February 2017
Contents
Purpose
Used to define database metadata
Syntax
ALTER DATABASE <cDatabase> 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 for the database <cDatabase>. The metadata to be applied to the database is specified in the <cMetaData> character string. For use with the MetaData Editor in the Data workspace, the <cMetaData> string should be in the format:
"name1=value;name2=value"
without internal quotes.
Alternatively, <cMetaData> can be a JSON string, in which case it is not modifiable or viewable in the MetaData Editor.
Example
// Name value pairs for use with the MetaData Editor alter database southwind metadata "customer=Lianja Inc.;contact=sales@lianja.com" open database southwind ? databaseMetaData() // --> 'customer=Lianja Inc.;contact=sales@lianja.com' // JSON string alter database sw2 metadata '{"purpose":"Documentation Test Database","owner":"Yvonne Milne"}' open database sw2 ? databasemetadata() // --> '{"purpose":"Documentation Test Database","owner":"Yvonne Milne"}'
