cascade check? It will enable to delete all foreign keys concerned date in all table having foreign keys?

Yes ))

Thank you pavienko. Can you tell how to delete a data in foreign key?

Foreign key control is to prevent deletion of data referenced from other tables. This is an element of the data integrity control system.

If you need to delete a referencing reference record, there are three solutions in DVBM when setting up a foreign key:

1. Make the field optional. Then, before deleting the reference record, it is necessary to write the value NULL in such a field
2. Enable cascading deletion. Then, when a reference record is deleted, all records that had a connection with it will be deleted.
3. Before deleting an entry in the directory, delete all entries associated with a foreign key yourself.

What kind of removal method do you need?

Thank you pavienko. Can you tell how to delete a data in foreign key?

the foreign key is equal to the id of the related table. show your architecture and then I can help
внешний ключ равен идентификатору связанной таблицы. покажи свою архитектуру и тогда я смогу помочь

SQLEXECUTE(DELETE TABLE WHERE  ID = (SELECT MAX(ID)  FROM TABLE));