Show tables in a database

Telegraf
1

Dear All,

What is the query to show tables in a database please?

Thanks a lot in advance

2

Show Measurements; I think, correct?
Thanks

3

@jwang

Yes, log into the database via terminal then with the following commands:

use databasename

It will say ‘Using database name’

Then you can run SHOW MEASUREMENTS and SHOW RETENTION POLICY

4

thanks a lot indeed.

5

it should be SHOW RETENTION POLICIES

1 Like