The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

I don’t know where to find the ddl

I don’t know where to find the ddl

0
Votes
1
Answer

I have been following the SQL course and I have noticed that I don’t have the DDL that’s next to ‘Grants’.
 

#, #
1 Answer

365 Team
0
Votes

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