CODEWITHSUNDEEP
tdengine
Jackson
Jackson

Reputation: 9

how to list all child tables under the specific super table in TDengine database?

how to list all child tables under the specific super table in TDengine database? Which SQL command should I use? I use select * from the super table but it only shows all the records, and I also tried to use select distinct(id) from the super table, with a unique id for each child table but it's troublesome, is there any convenient way?

Upvotes: 0

Views: 131

Answers (1)

zhaoyanggh
zhaoyanggh

Reputation: 285

use select tbname from db.stb because each child table has a unique table name

Upvotes: 1

Related Questions