Last answered:

30 Mar 2020

Posted on:

30 Mar 2020

0

I don't know where to find the ddl

I have been following the SQL course and I have noticed that I don't have the DDL that's next to 'Grants'.  
1 answers ( 0 marked as helpful)
Instructor
Posted on:

30 Mar 2020

0

Hi Mohamed!
Thanks for reaching out.
This is an unfortunate problem that although very rarely, we've observed that it may still occur for some versions of Workbench in combination with the relevant operating system. Oftentimes, completely removing MySQL and then installing an older, archived version, solves the issue.
However, should you get to this point, I'd suggest try finishing our course without using the DDL tab, and then try changing the version of MySQL that works for you, as the latter may consume a lot of time.
Before getting to that point, though, there's a trick and an alternative that may help you solve the problem.
First, please try refreshing the Schemas section on the left-hand side of the screen by pressing this tiny button.

Then, if this doesn't help, please click on the Inspector button, then go to the Tables tab and double-click on the name of the table of interest. The latter should change the tabs that appear just above, and you'll hopefully see  the DDL tab as an option.

Hope this helps.
Best,
Martin

Submit an answer