Question

Which command in sql is used to delete a tables entire data and its structure?

Answer 1

Answer:

Drop

please verify me my answer. Drop is correct answer

Answer 2

The command is Drop Table.

• The term SQL stands for Standard Query Language
• All of the data in a database is stored in tables, which are database objects. Data is logically arranged in tables using a row-and-column layout akin to a spreadsheet.
• This function can be used to delete a table from the dataset. The table structure is entirely eliminated, including any related data, rights, prompts, and limits.
• A user may have stored procedures and SQL views that relate to the SQL table.
• SQL Server does not, however, delete these stored procedures and views. Before eliminating a SQL table, the user must explicitly drop them and should then look into object dependencies.

#SPJ2