How to delete all data from all the tables in the sql server database

delete all data from all the tables in the sql server database

Solution

EXEC sp_MSforeachtable @command1 = “DELETE FROM ?”

About the Author

avatar