[ https://issues.jboss.org/browse/TEIID-2372?page=com.atlassian.jira.plugin... ] Ramesh Reddy edited comment on TEIID-2372 at 2/12/13 9:59 PM: -------------------------------------------------------------- I checked SQL/MED syntax here http://wiki.postgresql.org/wiki/SQL/MED, they do not seem to provide any standard DDL for this. I propose we do {code} ALTER [FOREIGN] TABLE|VIEW|PROCEDURE {name} [[COLUMN|PARAMETER] {sub-name}] ADD|DROP {prop-name} [TO {prop-value}] {code} was (Author: rareddy): I checked SQL/MED syntax here http://wiki.postgresql.org/wiki/SQL/MED, they do not seem to provide any standard DDL for this. I propose we do ALTER [FOREIGN] TABLE|VIEW|PROCEDURE {name} [[COLUMN|PARAMETER] {sub-name}] ADD|DROP {prop-name} [TO {prop-value}] -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira