Can I change the CASESPECIFIC attribute on a table after it has been created?

Database

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
2 REPLIES
N/A

Re: Can I change the CASESPECIFIC attribute on a table after it has been created?

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

Re: Can I change the CASESPECIFIC attribute on a table after it has been created?

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.