PostgreSQL: Deleting Records With Foreign Keys | Course | 2019

[@younneschebli8609]

All your videos are amazing and so clear! Thanks bro! 😃

[@beverlyeaster2152]

Thank you for this Sir! more power to you.

[@praff5308]

Very useful video, just what I needed!
Thanks :)

[@quylongvo9041]

Thanks buddy ! It helps me a lots

[@drigosantos]

como eu faço para alterar a estrutura da tabela para incluir o "ON UPDATE CASCADE" e "ON DELETE CASCADE"? Eu estou usando o Postbird e pelas opções de gerenciamento das tabelas eu não sei como fazer.

[@acminostgien3038]

what if i don't want to delete the person, and also the data is not nullable?

[@itech40]

Salem!
Thank you man :)

[@magekezen1697]

But explain us cascade ,please.

[@dogukan4283]

amazing , thank you

[@nirbhaysingh1388]

how to drop the foreign key constraint from the table

[@amigoscode]

ALTER TABLE table DROP CONSTRAINT constraint_fkey;.

[@whiteichigo880]

is there a way two delete both rows with a single command? instead of doing it twice?

[@amigoscode]

Yes simply use the IN keyword

[@whiteichigo880]

@@amigoscode can you elaborate more? I am using sql with netbeans (java) and I am trying to delete a row with foreign key.

[@rotkva_ns8154]

​@@whiteichigo880 DELETE FROM table_name WHERE field_name IN (value1, value2);

[@markusdavid5660]

@@rotkva_ns8154 No he meant the whole step. Instead of deleting the car first and then the person. He wanted to delete both in one command. I am searching for that too.

[@СтепанМартьянов-я1э]

good video, thank you

[@amigoscode]

You welcome

[@devracoon]

........

[@amigoscode]

.......