hasTable with Schema in mssql

[xJonahS]

Environment

Knex version: 2.0.0
Database + version: mssql
OS: windows 10

@smorey2

Bug

1. hasTable does not work with schema (withSchema("NAME")) in mssql. You get an error. The issue seems to be caused by this commit: c4a3abc

The SQL Statement does not filter for the schema anymore and only for the name of the table.

This part seems to be missing:

(taken from the mysql compiler)

2. Error message
   Returns false, when it should return true.

3. Config

const config: Knex.Config = { client: "mssql", connection: { user: process.env.DATABASE_USER, password: process.env.DATABASE_PASSWORD, server: process.env.DATABASE_HOST, port: Number(process.env.DATABASE_PORT), database: process.env.DATABASE_NAME, connectionTimeout: 60000, options: { trustServerCertificate: true, encrypt: true, }, }, };

[kibertoad]

Released in 2.1.0