Delete All Rows except headers from SQL table using Alteryx

[Puneet13]

Hi Everyone

Can anybody help me to provide SQL query which deletes all records except headers from SQL Table,

Thanks

[SGolnik]

What type of database do you need SQL for? i.e. MS SQL Server, Oracle, etc.

[Puneet13]

MS SQL server

[SGolnik]

To delete all of the data, but keep the table use this code changing target_table to your table name: DELETE FROM target_table;

[Puneet13]

I Have tried but it giving the attached error.

[SGolnik]

Normally when I receive that error, there is a spacing issue in the SQL related to copy/pasting. Try deleting all of the spaces and adding them back.