On Monday, July 15, 2024, sud <
suds1434@gmail.com> wrote:
Thank you for the confirmation.
And if someone wants to fully remove that column from the table , then the only option is to create a new table with an exact set of active columns and insert the data into that from the existing/old table and then rename it back to old. Is this correct understanding?
You haven’t removed the column from the table, you’ve removed the whole dang table while creating a new, wholly unrelated, one that just happens to have the same name. But the name of a table isn’t its primary key, though some places do use it for lookup purposes.
David J.