Marco,
I can offer a partial response. To get a list of tables by table type (tables and views): SELECT SYS_TABLE_TYPE, SYS_TABLE_NAME FROM SYS_TABLES GROUP BY SYS_TABLE_TYPE If you want to eliminate the system tables, add: "WHERE SYS_TABLE_TYPE <> 'SYSTEM TABLE'" To list the columns for a table: SELECT T2.SYS_COLUMN_NAME FROM SYS_TABLES T1,SYS_COLUMNS T2 WHERE T1.SYS_TABLE_NAME = 'mytable' AND T2.SYS_TABLE_ID = T1.SYS_TABLE_ID Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Groeneveld Sent: Sunday, September 02, 2007 4:55 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Oterro 3.5 / Oterro 8.0 for SnappMX 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
