Last answered:

01 Dec 2021

Posted on:

17 Nov 2021

0

what is ibfk? which he mentioned

he mentioned beside DROP FOREIGN KEY SALES_IBFK_1;
can't understand this

1 answers ( 0 marked as helpful)
Instructor
Posted on:

01 Dec 2021

1

Hi Israa!

Thanks for reaching out!
Explanation of the name:
ibfk = ib(InnoDB) fk (foreign key)
InnoDB is a general-purpose storage engine that balances high reliability and high performance. In MySQL 5.6, InnoDB is the default MySQL storage engine.
A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.
Otherwise, you can hover over a table and click on the tiny icon with info and note that the foreign keys are located in the "Foreign Keys" Tab. Thus, you'll see that in your table you are having certain columns that contain foreign keys. Also, the "Foreign key" tab represents the current state of the foreign keys in the database you are working on. For instance, if you have dropped a foreign key you can refresh the "Schemas" section and you will not see that foreign key in the column anymore.

Hope this helps.

Best,
Martin

Submit an answer