Creating a table
While creating at table dont we refer to database in which it should be created?
In the video lecture sales table was created without pointing to database ? As there is only single database sales we did not mention it?
1 answers ( 0 marked as helpful)
Hi Sai!
Thanks for reaching out.
Following the lectures to that point, we have created the 'sales' database, yes. Not only that, but we have set it as a default database in our session (in other words - basically, in our connection at the moment of working in Workbench).
Provided that we have a default database to work on, the tables we create will be part of that database.
Hope this helps.
Best,
Martin
Best,
Martin