---
title: "DDL Settings Details"
canonical: "https://docs.vaultspeed.com/space/VPD/3013017629/DDL%20Settings%20Details"
format: markdown
---
> 📝 The standard functionality of the DDL settings screen is explained in the Walkthrough article that you can find here: [https://vaultspeed.atlassian.net/wiki/spaces/VPD/pages/3013312538](https://vaultspeed.atlassian.net/wiki/spaces/VPD/pages/3013312538)

# External/Foreign Table Generation

The DDL settings functionality has been extended with variable support for INI and CDC layers. This now makes external/foreign table generation possible. The following variables are supported:

`{table_name}` - source table name.

`{schema_name}` - schema name. Schemas for INI and CDC layers can be defined using VaultSpeed parameters accordingly: SCHEMA_INI and SCHEMA_CDC.

 

Sample DDL settings preset (DDL/ETL Generation → DDL Settings) configured below, which then is applied in the “Apply DDL Settings“ screen.

![image](media://5a5828e5-0a16-496d-87c1-434f35e33496)

The preview for this code is shown below:

![image](media://019ba030-c09c-4c95-be23-2c13a3a776e2)


Sample generated code below:

```sql
CREATE EXTERNAL TABLE [moto_mktg_scn04].[addresses]
(
    [address_number] NUMERIC
   ,[street_name] VARCHAR(150)
   ,[street_number] NUMERIC
   ,[postal_code] VARCHAR(18)
   ,[city] VARCHAR(150)
   ,[province] VARCHAR(150)
   ,[update_timestamp] DATETIME2(7)
)
WITH ( 
LOCATION='/ini_data/moto_mktg_scn04.addresses.csv'
, DATA_SOURCE = AzureDataLakeStorage
, FILE_FORMAT = TextFileFormat
, REJECT_TYPE = VALUE
, REJECT_VALUE = 2500 
);
```