Subject | Metadata Descriptions? |
---|---|
Author | dr_bentonquest |
Post date | 2005-06-13T21:41:23Z |
Hi there,
The metadata of a table includes a "description" field for every field
of the table.
Now I wonder how do I fill in that metadata field, for instance when
creating a domain:
CREATE DOMAIN DCREATED AS
TIMESTAMP
DEFAULT current_timestamp
NOT NULL
DESCRIPTION 'Datetime of creation'
or perhaps when adding a field to a table:
ALTER TABLE CUSTOMERS
ADD CREATED DCREATED
DESCRIPTION 'Datetime of creation'
In the two examples above, the last line is invalid. So, how do I do this?
Thanks in advance,
-Benton
The metadata of a table includes a "description" field for every field
of the table.
Now I wonder how do I fill in that metadata field, for instance when
creating a domain:
CREATE DOMAIN DCREATED AS
TIMESTAMP
DEFAULT current_timestamp
NOT NULL
DESCRIPTION 'Datetime of creation'
or perhaps when adding a field to a table:
ALTER TABLE CUSTOMERS
ADD CREATED DCREATED
DESCRIPTION 'Datetime of creation'
In the two examples above, the last line is invalid. So, how do I do this?
Thanks in advance,
-Benton