Hi, What is the query for: 1. to grab all user defined tables and views 2. to grab all table fields for a table
In SQL Server we use: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME NOT LIKE 'sys%' AND TABLE_NAME <> 'dtproperties' ORDER BY TABLE_NAME SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTable' --- What is the .NET Provider name for Oterro 3.5 / 8.0 ? ProviderName="System.Data.Odbc" or an other name like System.Data.RbaseClient or System.Data.OtteroClient. For SQL Server we use: - ADO.NET 2.0 driver comes with SQL Server <add key="SnappDBProvider" value="System.Data.SqlClient" /> Best regards, Marco
