On Monday, July 15, 2024, sud &lt;<a href="mailto:suds1434@gmail.com">suds1434@gmail.com</a>&gt; wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div dir="ltr"><br></div><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Thank you for the confirmation. <br></div><div>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?</div></div></div></blockquote><div><br></div><div>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.</div><div><br></div><div>David J.</div><div><br></div>