SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes) DBMS

  • DELETE FROM table_name;
  • DELETE TABLE table_name;
  • DROP TABLE table_name;
  • None
Answer: DELETE FROM table_name;
1669 students attemted this question.


No Explanation Available.

Share this question with friends

Similar Questions

  1. Which is the correct query to delete the rows of employees whose exp is less than 10.

  2. Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?

  3. In SQL, which command is used to add new rows to a table?

  4. In SQL, which command is used to SELECT only one copy of each set of duplicate rows

  5. A particular DBMS uses SQL for extracting data. The SQL command "WHERE" is usually followed by:

  6. Match SQL language with SQL commands1)DDL i)Revok, Grant2)DML ii)rename a table3)TCL iii)insert, update4)DCL iv)rollback , commit

  7. Which command is used to remove all rows from a table ?

  8. Which one of the following command is used to delete the existing row in a table?

  9. Correct syntax query syntax to drop a column from a table is

  10. The statement in SQL which allows to change the definition of a table is

  11. In SQL, which command(s) is (are) used to change a table’s storage characteristics?

  12. DELETE FROM r; where r is relation. This command performs which of the following action?

  13. All DBMS systems use SQL as a command language.

  14. Which of the following refers to the number of attributes in a relation?

  15. The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

  16. Intersection of rows and columns is called ..........

  17. Which of these rows absolutely CANNOT be the primary key?

  18. The Database Management Query language is generally designed for the _____

  19. In the given query which of the keyword has to be inserted?

  20. A DBMS query language is designed to


Add Your Review

Your email address will not be published.

Subscribe to Newsletter!

Subscribe to get latest updates and information.