Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete and truncate?
- 4 Answers
- 6924 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkatesh kumar.s
Truncate:The truncate command deletes the rows in the
table,but not the structure of the table.
Cmd-truncate table tablename;
Drop:The drop command will drop the table from the databases.
Cmd-drop table tablename;
Delete:The delete cmd removes tuples from a relation.It
includes where clause to select the tuples to be deleted.
Cmd-delete from tablenmae where attribute-name="value" or value;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is building blocks of client/server?
Should database table names be capitalized?
What are the different types of languages that are available in the dbms?
What is dba in dbms?
What do you understand by correlated subqueries in dbms?
What are the advantages of dbms?
What is dbms and its advantages?
What is dbms with example?
How many rows can a database hold?
What is alternate key?
What are records and fields in a database?
Mention some advantages of using dbms.
What is information schema in database?
What are the disadvantages of a query?
What are foreign keys in database?
