Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 25944 Views
- I also Faced
- E-Mail Answers
Answer Posted / ......v......
TRUNCATE <table_name>;
This will only Remove table data and not structure of table
DROP <table_name>;
This will Remove table data and structure both
In both the cases data can be Rollbacked in SQL Server 2000
or 2005.....,But NOT POSSIBLE in other.........!
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
What is the maximum size of table in mysql?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
What is difference between oracle sql and mysql?
What is difference between statement and preparedstatement?
What is a mysql view?
What is mysql workbench used for?
Can I copy mysql data directory?
How do I install mysql?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
What is timestamp in mysql?
How big is a blob mysql?
What is pragma exception?
Does mysql scale well?
what is the difference between between and in operators in mysql?
What are the differences between char and varchar data types?
