I’m fairly new to Dreamfactory, it’s amazing sw and service.
When connecting to SQL Server, I have troubles with getting the list of DB tables, for instance under the Schema tag or elsewhere.
The tables in my SQL Server database don’t have specific shema, so they are under the ‘default’ dbo schema. However, Dreamfactory tries to get the list of tables with the T-SQL sentence like:
SELECT TABLE_NAME, TABLE_SCHEMA FROM [INFORMATION_SCHEMA].[TABLES] WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = 'something'
where something is my database name (I can see the queries in the SQL Server Profiler). Since the schema is not my database name but dbo, Dreamfactory finds nothing.
This cannot be changed under Schema field in service settings, no matter what I use (empty field, ‘default’ or ‘dbo’). I also found this information, which is rather confusing - where should I put ‘true’ or ‘false’ to default_schema_only parameter?
I’m using Dreamfactory in the cloud.
Many thanks for your help …