Jun 4, 2007 #1 Xzibit7 Technical User Joined Jun 20, 2006 Messages 172 Location US Is there anyway to delete all the records in a table(while still keeping the table format) in a automated fashion.
Is there anyway to delete all the records in a table(while still keeping the table format) in a automated fashion.
Jun 4, 2007 1 #2 lespaul Programmer Joined Feb 4, 2002 Messages 7,083 Location US this will delete all the records in a table but leave the table for future use: Code: DELETE FROM TableName Leslie Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual Essential reading for database developers: The Fundamentals of Relational Database Design Understanding SQL Joins Upvote 0 Downvote
this will delete all the records in a table but leave the table for future use: Code: DELETE FROM TableName Leslie Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual Essential reading for database developers: The Fundamentals of Relational Database Design Understanding SQL Joins
Jun 4, 2007 Thread starter #3 Xzibit7 Technical User Joined Jun 20, 2006 Messages 172 Location US Thanks Upvote 0 Downvote