MSSQL.schema_exists
- MSSQL.schema_exists(schema_name)
Check whether a schema exists.
- Parameters
schema_name (str) – name of a schema in the currently-connected database
- Returns
whether the schema exists
- Return type
bool
Examples:
>>> from pyhelpers.dbms import MSSQL >>> testdb = MSSQL(database_name='testdb') Creating a database: [testdb] ... Done. Connecting <server_name>@localhost:1433/testdb ... Successfully. >>> testdb.schema_exists('dbo') True >>> testdb.schema_exists('test_schema') # (if the schema [test_schema] does not exist) False >>> testdb.drop_database(verbose=True) # Delete the database [testdb] To drop the database [testdb] from <server_name>@localhost:1433 ? [No]|Yes: yes Dropping [testdb] ... Done.