Skip to content

Instantly share code, notes, and snippets.

@JasPanesar
Created June 25, 2013 17:10
Show Gist options
  • Save JasPanesar/5860317 to your computer and use it in GitHub Desktop.
Save JasPanesar/5860317 to your computer and use it in GitHub Desktop.
Quick Script to drop all Mura CMS 6.0 tables from a MS SQL Server. Copy, paste, and rename the Use statement to reference your Mura TableName.
/* MSSQL Script to delete Mura 6.0 installation tables
Be sure to replace your database name below inside the USE [] Statement */
USE [MyMuraDatabase]
GO
DROP TABLE [dbo].[tadcampaigns]
DROP TABLE [dbo].[tadcreatives]
DROP TABLE [dbo].[tadipwhitelist]
DROP TABLE [dbo].[tadplacementcategoryassign]
DROP TABLE [dbo].[tadplacementdetails]
DROP TABLE [dbo].[tadplacements]
DROP TABLE [dbo].[tadstats]
DROP TABLE [dbo].[tadzones]
DROP TABLE [dbo].[tcaptcha]
DROP TABLE [dbo].[tchangesets]
DROP TABLE [dbo].[tclassextend]
DROP TABLE [dbo].[tclassextendattributes]
DROP TABLE [dbo].[tclassextenddata]
DROP TABLE [dbo].[tclassextenddatauseractivity]
DROP TABLE [dbo].[tclassextendsets]
DROP TABLE [dbo].[tclustercommands]
DROP TABLE [dbo].[tclusterpeers]
DROP TABLE [dbo].[tcontent]
DROP TABLE [dbo].[tcontentassignments]
DROP TABLE [dbo].[tcontentcategories]
DROP TABLE [dbo].[tcontentcategoryassign]
DROP TABLE [dbo].[tcontentcomments]
DROP TABLE [dbo].[tcontentdisplaytitleapprovals]
DROP TABLE [dbo].[tcontenteventreminders]
DROP TABLE [dbo].[tcontentfeedadvancedparams]
DROP TABLE [dbo].[tcontentfeeditems]
DROP TABLE [dbo].[tcontentfeeds]
DROP TABLE [dbo].[tcontentobjects]
DROP TABLE [dbo].[tcontentpublicsubmissionapprovals]
DROP TABLE [dbo].[tcontentratings]
DROP TABLE [dbo].[tcontentrelated]
DROP TABLE [dbo].[tcontentstats]
DROP TABLE [dbo].[tcontenttags]
DROP TABLE [dbo].[tdirectories]
DROP TABLE [dbo].[temails]
DROP TABLE [dbo].[temailstats]
DROP TABLE [dbo].[temailreturnstats]
DROP TABLE [dbo].[tfiles]
DROP TABLE [dbo].[tformresponsepackets]
DROP TABLE [dbo].[tformresponsequestions]
DROP TABLE [dbo].[timagesizes]
DROP TABLE [dbo].[tmailinglist]
DROP TABLE [dbo].[tmailinglistmembers]
DROP TABLE [dbo].[tpermissions]
DROP TABLE [dbo].[tplugindisplayobjects]
DROP TABLE [dbo].[tplugins]
DROP TABLE [dbo].[tpluginscripts]
DROP TABLE [dbo].[tpluginsettings]
DROP TABLE [dbo].[tredirects]
DROP TABLE [dbo].[tsessiontracking]
DROP TABLE [dbo].[tsettings]
DROP TABLE [dbo].[tsystemobjects]
DROP TABLE [dbo].[ttrash]
DROP TABLE [dbo].[tuseraddresses]
DROP TABLE [dbo].[tuserremotesessions]
DROP TABLE [dbo].[tusers]
DROP TABLE [dbo].[tusersfavorites]
DROP TABLE [dbo].[tusersinterests]
DROP TABLE [dbo].[tusersmemb]
DROP TABLE [dbo].[tuserstags]
DROP TABLE [dbo].[tuserstrikes]
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment