[teiid-issues] [JBoss JIRA] (TEIID-3349) Allow column type to be altered

[ https://issues.jboss.org/browse/TEIID-3349?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3349: ------------------------------------- Looks like current ALTER support is limited to adding and removing the OPTIONS, but not modifying the TYPE information. This can be accomplished with following syntax {code} ALTER TABLE {table-name} ALTER COLUMN {column-name} TYPE {new-type}; {code} Note that this can be done only on source tables, not on View tables, as View table support with DDL was limited to the implicit columns based on the transformation of the View. For any column level changes (ADD, REMOVE, ALTER) , the transformation can be updated to reflect the new required change. -- This message was sent by Atlassian JIRA (v7.2.3#72005)