TheDeveloperBlog.com
C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
SQL DROP Table
SQL drop table query with sql, tutorial, examples, insert, update, delete, select, join, database, table, join
SQL DROP TABLEA SQL DROP TABLE statement is used to delete a table definition and all data from a table. This is very important to know that once a table is deleted all the information available in the table is lost forever, so we have to be very careful when using this command. Let's see the syntax to drop the table from the database. DROP TABLE "table_name"; Let us take an example: First we verify STUDENTS table and then we would delete it from the database. SQL> DESC STUDENTS;
4 rows in set (0.00 sec) This shows that STUDENTS table is available in the database, so we can drop it as follows: SQL>DROP TABLE STUDENTS; Now, use the following command to check whether table exists or not. SQL> DESC STUDENTS; Query OK, 0 rows affected (0.01 sec) As you can see, table is dropped so it doesn't display it. SQL DROP TABLE Example in MySQL
Let's see the command to drop a table from the MySQL database. DROP TABLE table_name; SQL DROP TABLE Example in Oracle
Let's see the command to drop a table from Oracle database. It is same as MySQL. DROP TABLE table_name; SQL DROP TABLE Example in Microsoft SQLServer
Let's see the command to drop a table from SQLServer database. It is same as MySQL. DROP TABLE table_name;
Next TopicSQL DELETE TABLE
|
Related Links:
- SQL Interview Questions (2021)
- Learn SQL Tutorial
- Top 45 SQL Server Interview Questions (2021)
- SQL SELECT RANDOM
- SQL SELECT AS
- SQL SELECT IN
- SQL SELECT from multiple tables
- SQL SELECT DATE
- SQL SELECT SUM
- SQL SELECT NULL
- SQL WHERE
- SQL AND
- SQL OR
- SQL WITH
- SQL ORDER BY ASC
- SQL ORDER BY DESC
- SQL ORDER BY RANDOM
- Learn Sql Server Tutorial
- SQL ORDER BY LIMIT
- SQL ORDER BY Multiple Columns
- SQL INSERT
- SQL INSERT Multiple Rows
- SQL UPDATE
- SQL UPDATE with JOIN
- SQL UPDATE DATE
- SQL DELETE
- SQL DELETE ROW
- SQL DELETE all rows
- SQL DELETE JOIN
- SQL DELETE duplicate rows
- SQL DELETE DATABASE
- SQL DELETE VIEW
- SQL JOIN
- SQL OUTER JOIN
- SQL LEFT JOIN
- SQL RIGHT JOIN
- SQL FULL JOIN
- SQL CROSS JOIN
- SQL PRIMARY KEY
- SQL FOREIGN KEY
- SQL COMPOSITE KEY
- SQL vs NoSQL
- SQL Quiz | SQL Online Test
- SQL vs SQLite
- SQL Data Types
- SQL Operators
- SQL CREATE Database
- SQL DROP Database
- SQL Syntax
- SQL RENAME Database
- SQL SELECT Database
- SQL Table
- SQL CREATE Table
- SQL DROP Table
- SQL DELETE TABLE
- SQL RENAME Table
- SQL TRUNCATE Table
- SQL COPY Table
- SQL SELECT COUNT
- SQL SELECT TOP
- SQL ORDER BY
- SQL TEMP Table
- SQL ALTER Table
- SQL SELECT
- SQL SELECT UNIQUE
- SQL SELECT DISTINCT
- SQL SELECT FIRST
- SQL SELECT LAST