---
schema_version: "1"
id: 5ffbb4ce5b19782b80d837773d35d3effaaaae8e57f8671ba32f507311af8dd1
title: Execute DDL Statements Example
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/db-connector/latest/database-connector-execute-ddl.md
canonical_url: https://docs.mulesoft.com/db-connector/latest/database-connector-execute-ddl
source_site: docs.mulesoft.com
content_type: documentation
content_hash: 4badf9cb01e5bb815e2a6be2e96c34ef47e15bc0be0752e47bdd5ba297bd9fe6
description: MuleSoft Documentation Site
release: "1.16"
latest: true
---
---
product: Database Connector
version: 1.16
is-latest-version: true
---

# Execute DDL Statements Example

> For the full documentation index, see: https://docs.mulesoft.com/llms.txt

Anypoint Connector for Database (Database Connector) **Execute DDL** operation enables to execute
DDL queries against a database. Data Definition Language (DDL) statements, are special types of SQL
statements that do not directly access or modify data. Instead, they create, modify, or destroy data
structures, stored procedures, and so on. You can also use DDL statements to create or modify data
within tables or other data structures.

## Configure the Execute DDL Operation in Studio

The following example shows how to configure the **Execute DDL** operation that creates a new table
named `electronic` with columns named `id`, `name`, `description`, `price`, and `discount`:

1.  In the **Mule Palette** view, search for `database` and select the **Execute DDL** operation.

2.  Drag the **Execute DDL** operation onto the Studio canvas.  
    The operation creates a table and returns `0` unless there is an error.

3.  In the **General** tab of the operation configuration screen, click the plus sign (**+**) next
    to the **Connector configuration** field to access the global element configuration fields.

4.  Specify the database connection information and click **OK**.

5.  Set the **SQL Query Text** field to the SQL query to execute, for example:

```xml
CREATE TABLE electronic(
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    description VARCHAR(255),
    price SMALLINT,
    discount TINYINT
```

The following screenshot shows the configuration in Studio:

![The Execute DDL operation configuration in Studio](/mulesoft/current/en-us/db-connector/latest/_images/database-executeddl.png)

Figure 1. Execute DDL configuration

In the XML editor, the `<db:execute-ddl>` configuration looks like this:

```xml
<db:execute-ddl config-ref="dbConfig">
    <db:sql>
        CREATE TABLE electronic(
            id INT AUTO_INCREMENT PRIMARY KEY,
            name VARCHAR(100),
            description VARCHAR(255),
            price SMALLINT,
            discount TINYINT
        )
    </db:sql>
</db:execute-ddl>
```

## See Also

- [Database Connector Examples](https://docs.mulesoft.com/db-connector/latest/database-connector-examples)

- [Salesforce Help](https://help.salesforce.com)