Menu
How to remove a column from an existing table?
I have a table MEN with Fname and Lname
I need to remove the Lname
How to do it?
410
You cannot use ALTER VIEW for removing a column. To recreate the view without the column, use CREATE OR REPLACE VIEW . From the Oracle documentation: Use the ALTER VIEW statement to explicitly recompile a view that is invalid or to modify view constraints.
ALTER TABLE MEN DROP COLUMN Lname If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
