I have a database in SQL CE (sdf file) and I need to get all names of the tables.
How to do it?
The syntax to get all table names with the help of SELECT statement. mysql> use test; Database changed mysql> SELECT Table_name as TablesName from information_schema. tables where table_schema = 'test'; Output with the name of the three tables.
select table_name from information_schema.tables where TABLE_TYPE <> 'VIEW'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With