Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to get all tables names in SQL CE database?

I have a database in SQL CE (sdf file) and I need to get all names of the tables.

How to do it?

like image 937
Gold Avatar asked Oct 25 '10 18:10

Gold


People also ask

How do I get a list of table names in mysql?

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.


1 Answers

select table_name from information_schema.tables where TABLE_TYPE <> 'VIEW'
like image 136
dcp Avatar answered Oct 07 '22 00:10

dcp