---
title: Deployment Options (Project)
description: Deployment Options (DeploymentOptions) select which optional statements the generated deployment scripts contain.
---

[Skip to content](https://knowledge.bigenius-x.com/deployment-options-project#main-content)

[Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en)

[![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/)

Open main navigation

Close main navigation

- [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new)
- [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en)
2. [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en)
3. [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties)

# Deployment Options (Project)

**Applies to**  
Platform: Microsoft SQL Server · Snowflake · Databricks · Fabric Lakehouse · Fabric Warehouse · Oracle

Deployment Options (`DeploymentOptions`) select which optional statements the generated deployment scripts contain. They decide whether a deployment drops and recreates tables and whether it creates schemas.

The dbt generators do not offer the property.

### Values

Select one or more values in the Deployment group of the Additional Settings in [Project Settings](https://knowledge.bigenius-x.com/manage-project-settings-and-generator-configuration?hsLang=en):

- `Generate Drop Table Statements`: the table scripts drop and recreate each table. Without it, a table is created only when it does not exist. On Microsoft SQL Server, the option also adds the statements that drop the foreign keys referencing a table before it is dropped.
- `Generate Drop Load Control Schema` (Snowflake only): the load control deployment starts with `DROP SCHEMA IF EXISTS` for the load control schema, with `CASCADE`.
- `Generate Create Schema If Not Exists Statements` (Databricks, Fabric Lakehouse): each layer header runs `CREATE SCHEMA IF NOT EXISTS`. It applies only with [Use Unity Catalog](https://knowledge.bigenius-x.com/unity-catalog-project?hsLang=en) `true` on Databricks and with [Target Platform](https://knowledge.bigenius-x.com/target-platform-project?hsLang=en) `Fabric` on Fabric Lakehouse. With Use Unity Catalog `false` or Target Platform `Azure Synapse`, the header runs `CREATE DATABASE IF NOT EXISTS` instead, whether the option is selected or not.
- `Generate Alter View Body Statements` (Databricks only): the deployment alters a view that already exists with `ALTER VIEW` and creates it otherwise. Without it, views are created with `CREATE OR REPLACE VIEW`.

![Deployment group of Project Settings in a Databricks project with Deployment Options open: Generate Drop Table Statements and Generate Create Schema If Not Exists Statements selected, Generate Alter View Body Statements cleared](https://knowledge.bigenius-x.com/hs-fs/hubfs/knowledge_base_screenshots/deployment-options-project-deployment-group.png?width=636&height=168&name=deployment-options-project-deployment-group.png)

### Defaults

- Microsoft SQL Server, Fabric Warehouse, Oracle: `Generate Drop Table Statements`.
- Snowflake: `Generate Drop Table Statements` and `Generate Drop Load Control Schema`.
- Databricks, Fabric Lakehouse: `Generate Drop Table Statements` and `Generate Create Schema If Not Exists Statements`.

With `Generate Drop Table Statements`, the default on every platform, each deployment deletes the data in the generated tables. The table scripts drop an existing table and create it empty: `DROP TABLE` and `CREATE TABLE` on Microsoft SQL Server and Fabric Warehouse, `DROP TABLE ... CASCADE CONSTRAINTS PURGE` on Oracle, and `CREATE OR REPLACE TABLE` on Snowflake, Databricks and Fabric Lakehouse. Clear the option before you deploy to tables whose data you want to keep.

On Databricks and Fabric Lakehouse, the option also applies to the load control log tables `execution_log` and `deployment_log`: with it, the load control deployment replaces them with `CREATE OR REPLACE TABLE`; without it, the deployment creates them with `CREATE TABLE IF NOT EXISTS`. On Microsoft SQL Server, the load control tables do not depend on Deployment Options: with [Deploy LoadControl](https://knowledge.bigenius-x.com/deploy-loadcontrol-project?hsLang=en) `true`, each deployment drops and creates them again.

To deploy a changed project into a target that already holds data, follow Redeploy and keep data in the Deployment article of your platform: [Microsoft SQL Server](https://knowledge.bigenius-x.com/microsoft-sql-server-deployment?hsLang=en#redeploy-and-keep-data), [Snowflake](https://knowledge.bigenius-x.com/snowflake-deployment?hsLang=en#redeploy-and-keep-data), [Databricks](https://knowledge.bigenius-x.com/databricks-deployment?hsLang=en#redeploy-and-keep-data), [Fabric Lakehouse](https://knowledge.bigenius-x.com/fabric-lakehouse-deployment?hsLang=en#redeploy-and-keep-data), [Fabric Warehouse](https://knowledge.bigenius-x.com/fabric-warehouse-deployment?hsLang=en#redeploy-and-keep-data), [Oracle](https://knowledge.bigenius-x.com/oracle-deployment?hsLang=en#redeploy-and-keep-data).

### Example

On Microsoft SQL Server without `Generate Drop Table Statements`, the table script of a Link starts with:

```
IF OBJECT_ID(N'[<schema>].[RDV_LNK_single_customer_hub_lnk]', N'U') IS NULL
BEGIN
    CREATE TABLE [<schema>].[RDV_LNK_single_customer_hub_lnk] (
    ...
```

With the option, the script drops the table first and then creates it.

### Release differences

- Generator 2.2: `Generate Create Schema If Not Exists Statements` is added.
- Generator 2.0: `Generate Alter View Body Statements` and `Generate Drop Load Control Schema` are added.

### Related articles

- Reference: [Use Unity Catalog (Project)](https://knowledge.bigenius-x.com/unity-catalog-project?hsLang=en), [Target Platform (Project)](https://knowledge.bigenius-x.com/target-platform-project?hsLang=en), [Deploy LoadControl (Project)](https://knowledge.bigenius-x.com/deploy-loadcontrol-project?hsLang=en)
- See also: [Deploy a Project in production](https://knowledge.bigenius-x.com/deploy-a-project-in-production?hsLang=en), [Manage Project settings and Generator configuration](https://knowledge.bigenius-x.com/manage-project-settings-and-generator-configuration?hsLang=en)

- [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content)

    - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines)
    - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working)
    - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account)
- [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en)
- [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en)
- [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content)

    - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration)
    - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions)
    - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features)
    - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects)
    - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches)
    - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections)
    - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview)
    - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps)
    - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms)
    - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping)
    - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships)
    - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality)
    - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes)
    - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling)
    - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts)
    - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings)
    - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace)
- [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content)

    - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse)
    - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse)
    - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks)
    - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake)
    - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server)
    - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle)
    - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts)
    - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders)
    - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment)
    - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment)
    - [Deployment with an Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-devops-pipeline)
    - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment)
    - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment)
    - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control)
    - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow)
    - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type)
    - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties)
    - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms)
- [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content)

    - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations)
- [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content)

    - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches)
    - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases)
    - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules)
    - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules)
- [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en)
- [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content)

    - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application)
    - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application)
    - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators)
- [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content)

    - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs)
    - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits)

- [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en)
- [Customer Portal](https://knowledge.bigenius-x.com/customer-portal)
- [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login)

[![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com)

<https://www.linkedin.com/company/bigenius> <https://www.youtube.com/@biGENIUS_DWA>

All rights reserved © 2025, biGENIUS AG