All Forums Database
mpsargent 2 posts Joined 06/11
15 Jun 2011
Can I change the CASESPECIFIC attribute on a table after it has been created?

Hello, I have some fields that I would like to modify/alter after the table has been created. They were created with a "CASESPECIFIC" attribute and I would like to change that to "NOT CASESPECIFIC", without having to drop the existing column. Can this be done? I have one more twist. I work in a corp. environment, so I do not have access to the "DBC" database tables to be able to modify the "UpperCaseFlag" on the columns.

Any help would be appreciated.
Mike

dnoeth 4628 posts Joined 11/04
15 Jun 2011

Hi Mike,
you have to use the ADD syntax:
ALTER TABLE mytab ADD existing_column NOT CASESPECIFIC

Btw, don't worry :-)
Even your dba will not be able to change the UpperCaseFlag by way of an update.

Dieter

Dieter

mpsargent 2 posts Joined 06/11
15 Jun 2011

Thank you soooooooo much. That does exactly what I needed, changes "CASESPECIFIC" to "NOT CASESPECIFIC" on an existing column without loosing any of the data in the column. Thank you again.

You must sign in to leave a comment.