24 lines
771 B
Markdown
24 lines
771 B
Markdown
---
|
|
layout: default_docs
|
|
title: Creating and Modifying Database Objects
|
|
header: Chapter 5. Issuing a Query and Processing the Result
|
|
resource: media
|
|
previoustitle: Performing Updates
|
|
previous: update.html
|
|
nexttitle: Chapter 6. Calling Stored Functions
|
|
next: callproc.html
|
|
---
|
|
|
|
To create, modify or drop a database object like a table or view you use the
|
|
`execute()` method. This method is similar to the method `executeQuery()`, but
|
|
it doesn't return a result. [Example 5.4, “Dropping a Table in JDBC](ddl.html#drop-table-example)
|
|
illustrates the usage.
|
|
|
|
<a name="drop-table-example"></a>
|
|
**Example 5.4. Dropping a Table in JDBC**
|
|
|
|
This example will drop a table.
|
|
|
|
`Statement st = conn.createStatement();`
|
|
`st.execute("DROP TABLE mytable");`
|
|
`st.close();` |