List of Tables in Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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).
 
You should be able to run a select statement from the
INFORMATION_SCHEMA.TABLES:

SELECT * FROM INFORMATION_SCHEMA.TABLES
 
Back
Top