Microsoft JDBC Driver - DDL Statements

JDBC Tutorials - Herong's Tutorial Examples - Version 3.03, by Dr. Herong Yang

JDBC Tutorials - 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

Conclusion:

DDL statements are used to create, alter or drop database objects like tables, views, indexes, or stored procedures.
DDL statements should be exectured 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

Table of Contents

About This Book

JDBC (Java Database Connectivity) Introduction

JDK (Java SE) Installation

Installing and Running Java DB - Derby

Derby (Java DB) JDBC Driver

Derby (Java DB) JDBC DataSource Objects

Java DB (Derby) - DML Statements

Java DB (Derby) - ResultSet Objects of Queries

Java DB (Derby) - PreparedStatement

MySQL Installation on Windows

MySQL JDBC Driver (MySQL Connector/J)