I am trying to empty all the tables in a mssql database so they are completely clean of any data for a fresh start, I've googled but I cant find much about it.
Anyone know the query?
Printable View
I am trying to empty all the tables in a mssql database so they are completely clean of any data for a fresh start, I've googled but I cant find much about it.
Anyone know the query?
TRUNCATE or DROP (tables only) works in MySQL, I quess for MsSQL it will work either, search on those keywords.