diff options
| author | Mark Newnham <mark@newnhams.com> | 2026-03-19 21:46:21 -0600 |
|---|---|---|
| committer | Mark Newnham <mark@newnhams.com> | 2026-03-19 21:46:21 -0600 |
| commit | fdfc1445b69ad8a219f2a84f9593c3cccf958da8 (patch) | |
| tree | 5ea55ca82c79aa2f4fa839686e2b19d32c96622d | |
| parent | 3094e4b43e9a26c786a97c6789c3bcadff348cc5 (diff) | |
| download | adodb-fdfc1445b69ad8a219f2a84f9593c3cccf958da8.tar.gz adodb-fdfc1445b69ad8a219f2a84f9593c3cccf958da8.tar.bz2 adodb-fdfc1445b69ad8a219f2a84f9593c3cccf958da8.zip | |
Reverts commit error removing metaTablesSql
| -rw-r--r-- | drivers/adodb-mssqlnative.inc.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/drivers/adodb-mssqlnative.inc.php b/drivers/adodb-mssqlnative.inc.php index 43a8564c..6a456cf3 100644 --- a/drivers/adodb-mssqlnative.inc.php +++ b/drivers/adodb-mssqlnative.inc.php @@ -80,7 +80,7 @@ class ADODB_mssqlnative extends ADOConnection { public bool $needsAffectedRowCount = false; var $metaDatabasesSQL = "select name from sys.sysdatabases where name <> 'master'"; - + var $metaTablesSQL="select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties'))"; var $metaColumnsSQL = "select c.name, t.name as type, @@ -994,6 +994,7 @@ class ADODB_mssqlnative extends ADOConnection { $mask = $this->qstr(($mask)); $this->metaTablesSQL .= " AND name like $mask"; } + $ret = ADOConnection::MetaTables($ttype,$showSchema); if ($mask) { |