Skip to content

Instantly share code, notes, and snippets.

@StefanoChiodino

StefanoChiodino/delete_all_umbraco_forms_data.sql

Created July 12, 2019 09:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save StefanoChiodino/39b263e2a5b29f23922c9b3608fcb9cb to your computer and use it in GitHub Desktop.
Save StefanoChiodino/39b263e2a5b29f23922c9b3608fcb9cb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
delete_all_umbraco_forms_data.sql
TRUNCATE TABLE [dbo].[UFRecordDataBit]
TRUNCATE TABLE [dbo].[UFRecordDataDateTime]
TRUNCATE TABLE [dbo].[UFRecordDataInteger]
TRUNCATE TABLE [dbo].[UFRecordDataLongString]
TRUNCATE TABLE [dbo].[UFRecordDataString]
-- Delete allows to remove rows with constraints, in this case we removed all rows
-- that may reference these just above, but the server wouldn't know!
DELETE FROM [dbo].[UFRecordFields]
TRUNCATE TABLE [dbo].[UFRecords]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment