difference between delete and truncate ? basic database questions
Anónimo
Delete command will delete whole data from the table and table as well,after that there is no existence of table (table is deleted permanently ). Truncate command will delete the data in the table but the structure of the table will remain,at any point of time we can use that structure.(structure of table will remain in the memory).used in testing purpose.