(schema)
| 30 | } |
| 31 | |
| 32 | dropSchema(schema) { |
| 33 | // DROP SCHEMA Can't drop schema if it is not empty. |
| 34 | // DROP SCHEMA Can't drop objects belonging to the schema |
| 35 | // So, call the admin procedure to drop schema. |
| 36 | const query = `CALL SYSPROC.ADMIN_DROP_SCHEMA(${ wrapSingleQuote(schema.trim()) }, NULL, ? , ?)`; |
| 37 | const sql = { query }; |
| 38 | sql.bind = [{ ParamType: 'INOUT', Data: 'ERRORSCHEMA' }, |
| 39 | { ParamType: 'INOUT', Data: 'ERRORTABLE' }]; |
| 40 | return sql; |
| 41 | } |
| 42 | |
| 43 | showSchemasQuery() { |
| 44 | return 'SELECT SCHEMANAME AS "schema_name" FROM SYSCAT.SCHEMATA WHERE ' + |
nothing calls this directly
no test coverage detected