What is the importance of the TRUNCATE statement?

1.	What is the importance of the TRUNCATE statement?
Answer» TRUNCATE TABLE name_of_table statement REMOVES the data efficiently and quickly from the table. The truncate statement can also be used to reset values of the identity columns along with data CLEANUP as shown below: TRUNCATE TABLE name_of_table RESTART IDENTITY; We can also USE the statement for removing data from multiple tables all at once by mentioning the table names separated by comma as shown below: TRUNCATE TABLE table_1, table_2, table_3;

Answer»

TRUNCATE TABLE name_of_table statement REMOVES the data efficiently and quickly from the table.
The truncate statement can also be used to reset values of the identity columns along with data CLEANUP as shown below:

TRUNCATE TABLE name_of_table RESTART IDENTITY;

We can also USE the statement for removing data from multiple tables all at once by mentioning the table names separated by comma as shown below:

TRUNCATE TABLE table_1, table_2, table_3;

Discussion

No Comment Found

Related InterviewSolutions

Differentiate between commit and checkpoint.
What are parallel queries in PostgreSQL?
Does PostgreSQL support full text search?
How will you take backup of the database in PostgreSQL?
How do you perform case-insensitive searches using regular expressions in PostgreSQL?
What is the main disadvantage of deleting data from an existing table using the DROP TABLE command?
What can you tell about WAL (Write Ahead Logging)?
How do you check the rows affected as part of previous transactions?
What do you understand by command enable-debug?
What do you understand by multi-version concurrency control?

What is the importance of the TRUNCATE statement?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment