开发者

How to get all tables names in SQL CE database?

开发者 https://www.devze.com 2023-01-21 03:27 出处:网络
I have a da开发者_StackOverflowtabase in SQL CE (sdf file) and I need to get all names of the tables.

I have a da开发者_StackOverflowtabase in SQL CE (sdf file) and I need to get all names of the tables.

How to do it?


select table_name from information_schema.tables where TABLE_TYPE <> 'VIEW'
0

精彩评论

暂无评论...
验证码 换一张
取 消