community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

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. 

 

CreateSchema.png

Moderator
Moderator

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?

 

 

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.  

Highlighted
Moderator
Moderator

Thank you. It´s a solution. Meanwhile I have created a stored procedure, which I can execute in Alteryx. Works also fine. 

Labels