Creating Tables

[Siegfried Heintze]

How do I automate the creation of tables with JDBC? Are there actual function calls or must I execute a generic sql statement such as CREATE TABLE ...

[Snigdha Solanki]

You can use executeUpdate method to execute SQL DDL Statements. statements that create a table,alter a table, or delete a table are examples of DDL statements.

 
Connection con;
...
Statement stmt = con.createStatement();

stmt.executeUpdate("CREATE TABLE EMPLOYEE " +
    "(NAME VARCHAR(32), ID INTEGER)");

[ July 11, 2002: Message edited by: Snigdha Solanki ]