Persism
Persism copied to clipboard
Add support for schema names with table names
We should have support to include the schema name as well as the table name when generating or using SQL.
e,g,
SELECT [identity], [First Name], [Last Name], [ContactName] FROM [Contacts]
s.b.
SELECT [identity], [First Name], [Last Name], [ContactName] FROM [dbo].[Contacts]
It is possible to have access to a DB where you would have multiple schema names. Currently Persism fails to find them.
It is also possible that a DB has multiple schemas with tables with the same name. Need to be able to handle that situation.