What are the tables in the database?
In this exercise, you'll once again create an engine to connect to 'Chinook.sqlite'
.
Before you can get any data out of the database, however, you'll need to know what tables it contains!
To this end, you'll save the table names to a list using the method .table_names()
on the engine and then you will print the list.
This exercise is part of the course
Introduction to Importing Data in Python
Exercise instructions
- Import the function
create_engine
from the modulesqlalchemy
. - Create an engine to connect to the SQLite database
'Chinook.sqlite'
and assign it toengine
. - Using the method
.table_names()
on the engineengine
, assign the table names of'Chinook.sqlite'
to the variabletable_names
. - Print the object
table_names
to the shell.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import necessary module
# Create engine: engine
# Save the table names to a list: table_names
# Print the table names to the shell
print(____)