Replies:

Hi! Unfortunately there is no way to UPDATE the %DESCRIPTION information on a table or column with SQL.
But you can add these information while CREATEing a table like this:

or this way for a column:

Please see CREATE TABLE | InterSystems SQL Reference | InterSystems IRIS Data Platform 2022.1 for more details.

By default the %DESCRIPTION information is projected to the Remarks column via JDBC:

As you can see the text comes from the %DESCRIPTION property:

This works also for the columns.
This is from JDBC:


This is from INFORMATION_SCHEMA.COLUMNS:



Andreas

By the way, why is SQL not available for selection in the codesnippets?


isn't SQL a first class citizen on the iris dataplatform?? ;-)

Open Exchange applications:
Followers:
Andreas has no followers yet.
Following:
Global Masters badges: