MSSQL.create_table
- MSSQL.create_table(table_name, column_specs, schema_name=None, verbose=False)
Create a table.
- Parameters
table_name (str) – name of a table
column_specs (str) – specifications for each column of the table
schema_name (str or None) – name of a schema; when
schema_name=None
(default), it defaults toDEFAULT_SCHEMA
(i.e.'dbo'
)verbose (bool or int) – whether to print relevant information in console, defaults to
False
Examples:
>>> from pyhelpers.dbms import MSSQL >>> testdb = MSSQL(database_name='testdb') Creating a database: [testdb] ... Done. Connecting <server_name>@localhost:1433/testdb ... Successfully. >>> tbl_name = 'test_table' >>> col_spec = 'col_name_1 INT, col_name_2 varchar(255)' >>> testdb.create_table(table_name=tbl_name, column_specs=col_spec, verbose=True) Creating a table: [dbo].[test_table] ... Done. >>> testdb.table_exists(table_name=tbl_name) True >>> testdb.get_column_names(table_name=tbl_name) ['col_name_1', 'col_name_2'] >>> # Drop the table [dbo].[test_table] >>> testdb.drop_table(table_name=tbl_name, verbose=True) To drop the table [dbo].[test_table] from <server_name>@localhost:1433/testdb ? [No]|Yes: yes Dropping [dbo].[test_table] ... Done. >>> # Delete the database [testdb] >>> testdb.drop_database(verbose=True) To drop the database [testdb] from <server_name>@localhost:1433 ? [No]|Yes: yes Dropping [testdb] ... Done.