The DELETE statement is used to delete or remove all the rows from the table. We can use where clause to delete some specific rows. We can roll back the DELETE operation. DELETE is slower than TRUCATE. It is a DML command. Table structure will not be lost.
The TRUNCATE statement is used to remove the all rows from an existing table. We can’t roll back the TRUNCATE operation. TRUCATE is faster than DELETE. It is a DDL command. Table structure will not be lost.
The DROP TABLE statement is used to delete an existing table definition, indexes, constraints, access privileges and all associated data. We can’t roll back the DROP operation. It is DDL command. Table structure will be lost.
- What is DBMS?
- What is RDBMS?
- Difference between DBMS and RDBMS
- What are various DDL commands in SQL?
- What are various DML commands in SQL?
- What are various DCL commands in SQL?
- Can you sort a column using a column alias?
- Is a null value same as zero or a blank space if not then what is the difference?
- How can you eliminate duplicate rows from a query result?
- Difference between TRUNCATE, DELETE and DROP commands?
- What is the difference between CHAR and VARCHAR2 datatype in SQL?
- What are the differences between sql and pl/sql?
- What are the transaction properties in sql?
- What is the sql case statement used for?
- How many types of aggregate functions are there in sql?
- What are scalar functions in sql?
- What is the difference between sql and mysql?
- What is the use of nvl function in sql?
- What do you mean by subquery?
- What are Indexes in SQL?
- How to create index in oracle sql?
- How to view index in oracle sql?
- How to get list of tables in oracle sql
- Difference between clustered and nonclustered indexes in oracle sql?
- How to update with select subquery in sql server
- Explain different types of index in sql server