DBA > Job Interview Questions > COBOL SQL Interview Questions

After a table is defined, can columns be removed

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

After a table is defined, can columns be removed ?

The only way to remove column from an existing table involves a migration program that extracts only the desired columns of data, redefining the table without the unwanted columns, then populating the new table. One have to handle all the old table's dependents programmatically.

(Continued on next question...)

Other Job Interview Questions