MSSQL-Server using wrong schema at update SQL string

TarzanHB posted 8 months ago in General


I have a MSSQL-Server with 3 schematas. If I'm trying to update a column of a table over the gui, the generated SQL String always used the first schemata from the database and ignores the schemata from the table. Example. Database contains table like this one here: ho.adress ro.street Update the table over the gui and the SQL String looks like this one.

UPDATE "database"."ho"."city" ...

(off course this example with the schemata doesn't make sense, it's only to show the problem ;-) )

Thanks for any help.

Please login to leave a reply, or register at first.