From fe841a682b32715a4a4960300ef8c5dc13b385ad Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?C=C3=A9dric=20GARDIENNET?= Date: Thu, 12 Jan 2017 15:25:29 +0100 Subject: [PATCH] ref #2597 Fix function getListTablesSQL() for SQL Server --- lib/Doctrine/DBAL/Platforms/SQLServerPlatform.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/Doctrine/DBAL/Platforms/SQLServerPlatform.php b/lib/Doctrine/DBAL/Platforms/SQLServerPlatform.php index 9a5a94daa97..d4af27ec9e6 100644 --- a/lib/Doctrine/DBAL/Platforms/SQLServerPlatform.php +++ b/lib/Doctrine/DBAL/Platforms/SQLServerPlatform.php @@ -818,7 +818,7 @@ public function getListTablesSQL() { // "sysdiagrams" table must be ignored as it's internal SQL Server table for Database Diagrams // Category 2 must be ignored as it is "MS SQL Server 'pseudo-system' object[s]" for replication - return "SELECT name FROM sysobjects WHERE type = 'U' AND name != 'sysdiagrams' AND category != 2 ORDER BY name"; + return "SELECT SCHEMA_NAME(uid) + '.' + name as name FROM sysobjects WHERE type = 'U' AND name != 'sysdiagrams' AND category != 2 ORDER BY name"; } /**