Hi Everyone
Can anybody help me to provide SQL query which deletes all records except headers from SQL Table,
Thanks
What type of database do you need SQL for? i.e. MS SQL Server, Oracle, etc.
MS SQL server
To delete all of the data, but keep the table use this code changing target_table to your table name: DELETE FROM target_table;
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.