List of Tables in Database

[Guest]

Hello,

Can anyone tell me how I can get a list of the current tables in a SQL
Server CE database?
I am using VS 2005 on a Pocket PC 2003 Device.

Thanks,
Mark

 

[Ilya Tumanov [MS]]

Please execute this query: "Select table_type, table_name From
Information_Schema.Tables".

--
Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).

 

[Guest]

You should be able to run a select statement from the
INFORMATION_SCHEMA.TABLES:

SELECT * FROM INFORMATION_SCHEMA.TABLES