search

shafayetShafee / interactive-sql

A Quarto Extension to run sql examples interactively
https://shafayetshafee.github.io/interactive-sql/example-revealjs.html
MIT License
33 stars 0 forks source link

SHOW TABLES #2

Closed dannyvolkaerts closed 7 months ago

dannyvolkaerts commented 7 months ago

Hi,

Thank you for the nice extention! I like using it for my courses. One question though:

How can I use the SHOW TABLES command? In SQLite it should be .tables or tables but I can't manage to run this without error.

Thank you!

shafayetShafee commented 7 months ago

Yes, .tables is not working on the SQLite playground (sqlime) either. And interactive-sql is using that playground behind the scene. So .tables won't work.

In that case, try the command 

SELECT * FROM sqlite_master WHERE type = 'table';
dannyvolkaerts commented 7 months ago

ok, thank you - that does the job

shafayetShafee commented 7 months ago

I am closing the issue then.