Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialRodrigo Muñoz
Courses Plus Student 20,171 PointsHow can I get a list of the tables in a database?
I have a database that I don't know which tables are there. Is there a way I can get a list of the tables running a query?
2 Answers
Steven Parker
231,184 PointsThe method varies with the type of database. For SQLite you can enter ".tables" at the command prompt.
mike gilbert
4,935 Pointsshow tables;
Codi Hasbrouck
41 PointsIs this the same as asking ' SELECT * FROM "all" ' ?
Rodrigo Muñoz
Courses Plus Student 20,171 PointsRodrigo Muñoz
Courses Plus Student 20,171 PointsHow can I do that in Big query?
Steven Parker
231,184 PointsSteven Parker
231,184 PointsIs that a database type? I'm not familiar with it — try consulting the documentation.
Rodrigo Muñoz
Courses Plus Student 20,171 PointsRodrigo Muñoz
Courses Plus Student 20,171 PointsOk, Thank you