Page 1 Delete all the rows from all the tables in SQL Server If you are in situation where you just want empty database structure, without having data in it. Run following select statement which will generate set of delete statement to delete all the records for all the tables in your database. SELECT 'Delete from ' + Table_Catalog + '.' + Table_Schema + '.' + Table_Name + ';' FROM INFORMATION_SCHEMA.TABLES WHERE Table_Type = 'BASE TABLE' ORDER by TABLE_NAME In case your database is large and you want to know status of which table is currently getting deleted you can use following: SELECT 'Print(''Delete started for ' + Table_Catalog + '.' + Table_Schema + '.' + Table_Name + ''');' + 'Delete from ' + Table_Catalog + '.' + Table_Schema + '.' + Table_Name + ';' + 'Print(''Delete done for ' + Table_Catalog + '.' + Table...


Nice Blog! Flyttstadning Lulea ar den perfekta losningen for dig som vill lamna din bostad i toppskick vid flytt. En professionell flyttstadning omfattar noggrann rengoring av kok, badrum, golv, fonster och alla ovriga ytor for att uppfylla hyresvardens eller koparens krav. Genom att anlita experter sparar du bade tid och energi samtidigt som du far ett garanterat rent resultat. Oavsett om du flyttar fran en lagenhet, villa eller kontorslokal hjalper professionell flyttstadning dig att gora overlamningen smidig och problemfri. Valj Flyttstadning Lulea for en trygg, effektiv och bekvam flyttupplevelse.
ReplyDelete