how to get a listing of tables in sql mobile 2005 database

[Optimus]

HI all,

Does any one know how to get a listing of all of the tables located
in your sql mobile 2005 using .net compact framework?

Thanks in advance!

 

[Simon Hart]

You mean resolve them? I don't think you can do this. You have to know what
tables exist in order to read them.

Maybe ask the question here might help:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1

Regards
Simon.

 

[Pete Vickers]

Hi,
should be 'Select * from information_schema.tables' to get a list of the
tables.

Then for the columns, 'Select * from information_schema.columns where
table_name = ' ....


HTH

Pete