Sql Server Question - نوشته شده در (838 Views)
Advanced Member
Carefree
مطلب: 4224
4224
Is there an easy way to strip all the data from a Sql Server database (retaining structure, etc)? I exported it, opened in Access and deleted it all ... only to find that I can't "upsize" it to Sql 2012.
 پیش‌فرض مرتب‌سازی برای تاریخ DESC به معنی جدیدترین است  
 تعداد در صفحه 
نوشته شده در
Forum Admin
HuwR
مطلب: 20611
20611
just create a script that does a TRUNCATE [TABLENAME] on all the tables

however be careful as the forum requires some data or it will not run smile ie it needs the config table, and a default forum and an admin user
 
شما باید یک متن وارد کنید