TheDeveloperBlog.com
C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
SQLite Drop Table
SQLite Drop Table with history, features, advantages, installation, commands, syntax, datatypes, operators, expressions, databases, table, crud operations, clauses, like, glob, limit, and clause, advance sqlite
SQLite Drop TableIn SQLite, DROP TABLE statement is used to remove a table definition and all associated data, indexes, triggers, constraints and permission specifications associated with that table. Syntax: DROP TABLE database_name.table_name; Note: You must be very careful while using the DROP TABLE command because once the table is deleted then all the information available in the phone is destroyed and you cannot recover.Let's take an example to demonstrate how to delete a table in SQLite. We have already two tables "DEPARTMENT" and "STUDENT". We can verify it by using .tables command. 
So you can see that we have two tables. Let's delete the "STUDENT" table. DROP TABLE STUDENT; 
You can verify it by using .tables command. 
You can see only one table is here in the database. It means the other table is dropped.
Next TopicSQLite Insert Query
|
Related Links:
- Learn SQLite Tutorial
- SQLite History
- SQLite Interview Questions (2021)
- SQLite Data Types
- SQLite Operators
- SQLite Features
- SQLite Advantages and Disadvantages
- SQLite Installation
- SQLite Commands
- SQLite Syntax
- SQLite Expressions
- SQLite Create Database
- SQLite Attach Database
- SQLite Detach Database
- SQLite Create Table
- SQLite Like Clause
- SQLite Drop Table
- SQLite Insert Query
- SQLite Select Query
- SQLite Joins
- SQLite Update Query
- SQLite Delete Query
- SQLite Where Clause
- SQLite And Clause
- SQLite OR Clause
- SQLite Glob Clause
- SQLite Limit Clause
- SQLite Order by Clause
- SQLite juliandday
- SQLite strftime
- SQLite time
- SQLite Group by Clause
- SQLite Having Clause
- SQLite Distinct Keyword
- SQLite Union
- SQLite Union All
- SQLite Inner Join
- SQLite Outer Join
- SQLite Cross Join
- SQLite Date and Time
- SQLite date
- SQLite datetime
- SQLite now
- SQLite Aggregate Functions
- SQLite MIN Function
- SQLite MAX Function
- SQLite AVG Function
- SQLite COUNT Function
- SQLite SUM Function
- SQLite Triggers
- SQLite Trigger After Insert
- SQLite Trigger After Update
- SQLite Trigger After Delete
- SQLite Drop Trigger
- SQLite Primary Key
- SQLite Foreign Key
- SQLite Import
- SQLite Export