Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete and truncate?
- 4 Answers
- 6867 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
Enlist some commands of ddl, dml, and dcl.
How to debug stored procedures?
hello to all i want code for like this site "Submit Question" page.please give answers thanks.
What is the meaning of flat file database?
Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com
How do you set a primary key?
What is cold backup, hot backup, warm backup recovery?
Define database lock?
What is the rdbms concept in sql?
Compare a hierarchical and network database model?
What are records and fields in a database?
What are new features postgre 9.1?
What is Data Redundancy and Consistency ?
How do you notify dbpak about stored procedure?
How do I add a file to a database?
