Consult everybody:
Used to EXPRESS the 2014 version of a single database capacity limitation, I wanted to build 10 tables, fill after 10 tables, delete a table, so as not to exceed capacity,
Delete table has two kinds of operation, one kind is deleting content, table is the Delete from tablename (where 1=1), one is to Delete the entire table (drop table table name; Table delete didn't, can be built again), could you tell me what is the difference between these two kinds of operation? To control database capacity effect?

CodePudding user response:

Big difference? A log, a no log, a speed and a slow
Three difference, see here