HomeHome Product Discus... Product Discus...SmithCartSmithCartSQL script - clear product database from DNNSQL script - clear product database from DNN
Previous
 
Next
New Post
5/19/2012 8:16 AM
 

Hello again my Smith Cart friends!

 

I was told by my ISP that "I can run sql scripts against the db from DNN", and that you might have such a script to remove all the products from my portal's database.

 

This would be much quicker for me to clear out my test portal's product database, rather than deleting each one manually (over 1000).

 

Thanks! Alex

 
New Post
6/4/2012 7:22 AM
 

Not sure if you still needed help with this but you can use the following SQL query to remove all rows from a table, while keeping the columns intact: DELETE FROM table_name

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartSQL script - clear product database from DNNSQL script - clear product database from DNN