https://supabase.com/ logo
Hi All, I'm unable to drop a column though I remov...
# help
u
Hi All, I'm unable to drop a column though I removed the foreign key constrain on the column using the UI and made the cells NULL. What is going wrong? thanks!!!!
n
Hello @unknown1337! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
g
You might be able to use the 2nd answer from this https://stackoverflow.com/questions/5347050/postgresql-sql-script-to-get-a-list-of-all-tables-that-have-a-particular-column to see if you have any fk still pointing to this column.
s
You have another table using this column as its reference column. Check your other tables for this.