Microsoft JDBC Driver - DDL Statements

JDBC for SQL Server - Herong's Tutorial Examples

∟Microsoft JDBC Driver - DDL Statements

This chapter provides tutorial notes on executing DDL statements with Microsoft JDBC Driver. Topics include creating schemas; creating, altering and dropping tables.

Executing "Update" Statements - executeUpdate()

"CREATE SCHEMA" Statements

"CREATE TABLE" Statements

"ALTER TABLE" Statements

"DROP TABLE" Statements

Takeaways:

DDL (Data Definition Language) statements are used to create, alter or drop database objects like tables, views, indexes, or stored procedures.
DDL statements should be executed with executeUpdate() method.
There is no issue to execute DDL statements, like CREATE SCHEMA, CREATE TABEL, ALTER TABLE, and DROP TABLE, on MS SQL Server though the JDBC API