How to execute dynamic CREATE TABLE DDL to create tables in SQL server?

Question

Hello everyone,

I'm trying to generate a dynamic create table DDL script using Alteryx. Upto creation of the DDL script is fine but now I want to execute that to create all those tables in my SQL Server database. Can anyone of you please guide me how to do that?

Thanks in advance.

BrandonB · Answer

This link should help if you look at MarqueeCrew's response: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Create-table-from-schema-definition/td-p/105348