Hello master,

Use this:

SELECT * FROM INFORMATION_SCHEMA.TABLES

Regards,
João Paulo Figueira
Device Application Development MVP

Here is code that you can use :

/// <summary>
/// Return the list of user tables
/// </summary>
/// <param name="connection"></param>
/// <returns></returns>
private static string[] EnumTables(
SqlCeConnection connection
)
{
if (connection == null)
throw new ArgumentNullException("connection");
return EnumTables(connection, TableTypeFilter.User);
}
/// <summary>
/// Return the filtered list of tables
/// </summary>
/// <param name="connection"></param>
/// <param name="filter">Specify type of table to list</param>
/// <returns></returns>
private static string[] EnumTables(
SqlCeConnection connection,
TableTypeFilter filter
)
{
if (connection == null)
throw new ArgumentNullException("connection");
SqlCeCommand cmd;
IDataReader reader;
ArrayList result = new ArrayList();
cmd = connection.CreateCommand();
// Configure command
switch(filter)
{
case TableTypeFilter.None:
return null;
case TableTypeFilter.Both:
cmd.CommandText = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES";
break;
case TableTypeFilter.System:
cmd.CommandText = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE
TABLE_TYPE = 'System'";
break;
case TableTypeFilter.User:
cmd.CommandText = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE
TABLE_TYPE = 'TABLE'";
break;
}
bool wasOpened = (connection.State == ConnectionState.Open);
if (!wasOpened) connection.Open();
// Create the datareader
reader = cmd.ExecuteReader();
while(reader.Read())
result.Add(reader.GetString(0));
reader.Close();
reader.Dispose();
if (!wasOpened) connection.Close();
return (string[])result.ToArray(typeof(string));
}
/// <summary>
/// Enumerate table types
/// </summary>
[Flags]
internal enum TableTypeFilter
{
/// <summary>
/// No table is returned
/// </summary>
None = 0,
/// <summary>
/// Only user tables are retrieved
/// </summary>
User = 1,
/// <summary>
/// Only system tables are retrieved
/// </summary>
System = 2,
/// <summary>
/// Both user and system tables are retrieved
/// </summary>
Both = 3
}