I tried to create a new Schema with Pre SQL with the following statements, which work fine in the Microsoft SQL Server Management Studio but now in Alteryx: * CREATE SCHEMA Sales AUTHORIZATION [dbo] -> No error message, but also no new Schema. * CREATE SCHEMA Sales -> No error message and also no new Schema. I have no problem to create a new DB-table with an existing schema. But this is not what I need. I appreciate any suggestions.

Create Schema in Pre Ceate SQL Statement don´t work

I tried to create a new Schema with Pre SQL with the following statements, which work fine in the Microsoft SQL Server Management Studio but now in Alteryx:

CREATE SCHEMA Sales AUTHORIZATION [dbo] -> No error message, but also no new Schema.
CREATE SCHEMA Sales -> No error message and also no new Schema.

I have no problem to create a new DB-table with an existing schema. But this is not what I need. I appreciate any suggestions.

Output

Accepted answers

JakeS

Hi @CaptainJaneway

I think this post may be what you are looking for:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Create-table-from-schema-definition/m-p/105348#M33921

All comments

JakeS

Hi @CaptainJaneway

Based on the screenshot, you are trying to create a Schema while appending to an existing database. If you change the Output option to "Create" do you have the same issue? Do you have the permissions for the database to create a schema?

CaptainJaneway

I choosed an existing database and database-table. One step before the Output Tool I use the "Select Records"-Tool with 0 rows. It´s not my intention to put new data in the database-table. I just want create a new schema and as far as I can see, the pre or post sql statement is maybe the only way to do so. I have all permissions on the database.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703