Removing Column Format

Database
Enthusiast

Removing Column Format

How can the Format defined for a column be removed ?
1 REPLY
Enthusiast

Re: Removing Column Format

You can use Alter DML for this:

Alter table table_name
add existing_column_name data_type; //without format phrase

But you can't change the column attributes if it requires modification of internal storage of data.

In that case you need to create a new table.

Regards,
Deepu