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

Output Data

Atom

Hi,

Output Data to SQL.

Alteryx is creating output table with fields set with NULL option.

How to set certain fields as NOT NULL in output table in alteryx?

Thanks.

Alteryx Certified Partner

Hi @Anurag26 

 

Check this topic: Create Database Table Primary Key in Alteryx

 

You need to use Post-SQL statement:

 

ALTER TABLE YourTable
ALTER COLUMN YourColumn  NOT NULL;

Cheers, 

Atom

Every time i run the workflow will it execute the alter query?

Since in the first execution the column was already created.

Labels