Persism icon indicating copy to clipboard operation
Persism copied to clipboard

Add support for schema names with table names

Open sproket opened this issue 3 years ago • 0 comments

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.

sproket avatar Dec 04 '21 09:12 sproket