Platform
Business Intelligence Embedded Analytics Professional Services Security
Features
bipp Data Modeling Layer Visual SQL Data Explorer Data Visualization Git-based Version Control In-Database SQL Editor Scheduled Delivery and Alerts Real Time BI
Pricing
Resources
Blog Reports Release Notes Community Compare
Learn
Documentation bipp Tutorial Why bipp? SQL Tutorial Definitions
Company
About Meet The Team Careers News Case studies Disclosure Privacy Terms
Connect
Request Demo Support Contact Us

Sign in
Try for free

SQL Tutorial Home

SQL SELECT Statement
SQL ORDER BY and SQL LIMIT
Using SQL WHERE Clause With Comparison Operators
Using Logical Operators in WHERE clause
SQL BETWEEN and SQL LIKE in WHERE Clause
SQL IS NULL Operator in WHERE Clause
SQL Data Types
SQL CASE Clause in SQL Queries

SQL GROUP BY Clause in a SELECT Query
Aggregate Functions in SQL
SQL Having Clause
SQL Subqueries: The Super Powerful SQL Feature
SQL DISTINCT Clause
SQL Date and Time Functions and Data Types
SQL String Functions

SQL Correlated Subqueries Increase the Power of SQL
SQL Window Functions
SQL Window Function Examples
Selecting Data From Multiple Tables: SQL JOINS
Visual Representation of SQL JOINS
Query Optimization
SQL Indexes

1. Basics
How to Compare Arrays in PostgreSQL
How to Concatenate Strings in PostgreSQL
How to Convert the Case of a String
How to Create an Array
How to Insert Array Data Into a Table
How to Insert Data Into an Array
How to Modify Arrays
How to Query Arrays
How to Replace Substrings
How to Trim Strings
How to Use string_agg()
How to Use substring()
How to Use substring() with Regular Expressions
How to Insert
How to Update
How to Delete
2. Database Management
How to Create a Table
How to Drop a Table
How to Rename a Table
How to Truncate a Table
How to Duplicate a Table
How to Add a Column
How to Drop a Column
How to Rename a Column
How to Add a Default Value to a Column
How to Remove a Default Value From a Column
How to Add a Not Null Constraint
How to Remove a Not Null Constraint
How to Create an Index
How to Drop an Index
How to Create a View
How to Drop a View
How to Alter Sequence
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Use BETWEEN Correctly
How to Query Date and Time
How to Group by Time
How to Round Timestamps
How to Convert Local Time to UTC
4. Analysis
How to Use Lateral Joins
How to Use nullif()
How to Get the First Row per Group
How to Use generate_series to Avoid Gaps In Data
How to Do Type Casting
How to Write a Common Table Expression
How to Import a CSV
How to Compare Two Values When One Is Null
How to Use Coalesce
How to Write a Case Statement
How to Query a JSON Column
How to Use Filter Clause to Have Multiple Counts
How to Calculate Cumulative Sum-Running Total

1. Basics
How to Concatenate Strings in MS-SQL Server
How to Convert the Case of a String
How to replace a Substring in a String
How to Trim Strings
How to Use string_agg()
How to Use substring()
How to Insert
How to Update
How to Delete
2. Database Management
How to Create a Table in MS-SQL
How to Drop a Table in MS-SQL
How to Rename a Table in MS-SQL
How to Truncate a Table in MS-SQL
How to Duplicate a Table in MS-SQL
How to Add a Column in MS-SQL
How to Drop a Column in MS-SQL
How to Rename a Column in MS-SQL
How to Add a Default Value to a Column in MS-SQL
How to Remove a Default Value From a Column in MS-SQL
How to Add a Not Null Constraint in MS-SQL
How to Remove a Not Null Constraint in MS-SQL
How to Create an Index in MS-SQL
How to Drop an Index in MS-SQL
How to Create a View in MS-SQL
How to Drop a View in MS-SQL
How to Alter Sequence in MS-SQL
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Use BETWEEN Correctly
How to Query Date and Time in MS-SQL
How to Group by Time
How to Extract a Component From a Datetime
4. Analysis
How to Use Lateral Joins
How to Use nullif()
How to Get the First Row per Group
How to Do Type Casting in MS-SQL
How to Write a Common Table Expression
How to Import a CSV
How to Use Coalesce
How to Write a Case Statement
How to Query a JSON Column
How to Calculate Cumulative Sum-Running Total

1. Basics
How to Concatenate Strings in MySQL
How to Convert the Case of a String
How to replace a Substring in a String
How to Trim a String
How to use group_concat()
How to do you Use a substring()
How to Use substring() with Regular Expressions
How to use insert into statement
How to use Update statement in SQL
How to use Delete SQL Statement
2. Database Management
How to Create a Table in MySQL
How to Drop a Table in MySQL
How to Rename a Table in MySQL
How to Truncate a Table in MySQL
How to Duplicate a Table in MySQL
How to Add a Column in MySQL
How to Drop a Column in MySQL
How to Rename a Column in MySQL
How to Add a Default Value to a Column in MySQL
How to Remove a Default Value From a Column in MySQL
How to Add a Not Null Constraint in MySQL
How to Remove a Not Null Constraint in MySQL
How to Create an Index in MySQL
How to Drop an Index in MySQL
How to Create a View in MySQL
How to Drop a View in MySQL
How to Alter Sequence in MySQL
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Use BETWEEN Correctly
How to Query Date and Time in MySQL
How to Group by Time
How to Round Timestamps
4. Analysis
How to Use nullif()
How to Get the First Row per Group
How to Do Type Casting in MySQL
How to Write a Common Table Expression
How to Import a CSV
How to Use Coalesce
How to Write a Case Statement
How to Query a JSON Column
How to Calculate Cumulative Sum-Running Total

1. Basics
How to Concatenate Strings in Oracle
How to Convert the Case of a String
How to Replace Substrings
How to Trim Strings
How to Use listagg()
How to Use substring()
How to Use substring() with Regular Expressions
How to Insert
How to Update
How to Delete
2. Database Management
How to Create a Table
How to Drop a Table
How to Rename a Table
How to Truncate a Table
How to Duplicate a Table
How to Add a Column
How to Drop a Column
How to Rename a Column
How to Add a Default Value to a Column
How to Remove a Default Value From a Column
How to Add a Not Null Constraint
How to Remove a Not Null Constraint
How to Create an Index
How to Drop an Index
How to Create a View
How to Drop a View
How to Alter Sequence
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Use BETWEEN Correctly
How to Query Date and Time
How to Group by Time
How to Round Timestamps
4. Analysis
How to Use nullif()
How to Get the First Row per Group
How to Do Type Casting
How to Write a Common Table Expression
How to Import a CSV
How to Use Coalesce
How to Write a Case Statement
How to Query a JSON Column
How to Use Filter Clause to Have Multiple Counts
How to Calculate Cumulative Sum-Running Total

1. Basics
How to Concatenate Strings in BigQuery
How to Convert the Case of a String
How to replace a Substring in a String
How to Trim a String
How to Use string_agg()
How to use substring() function
How to Use substring() with Regular Expressions
How to Use BETWEEN Correctly
How to use insert into statement
How to use Update statement in SQL
How to use Delete SQL Statement
2. Database Management
How to Create a Database in BigQuery
How to Create a Table in BigQuery
How to Drop a Table in BigQuery
How to Rename a Table in BigQuery
How to Truncate Table in BigQuery
How to Duplicate a Table in BigQuery
How to Add a Column in BigQuery
How to Drop a Column in BigQuery
How to Add a Default Value to a Column in BigQuery
How to Add a Not Null Constraint in BigQuery
How to Remove a Not Null Constraint in BigQuery
How to Create a View in BigQuery
How to Drop a View in BigQuery
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Query Date and Time
How to Group by Time
How to Round Timestamps
4. Analysis
How to Use nullif()
How to Get the First Row per Group
How to Do Type Casting
How to Write a Common Table Expression
How to Compare Two Values When One Is Null
How to Use Coalesce
How to Write a Case Statement
How to Calculate Cumulative Sum-Running Total

SQL tutorial
> oracleSQL
> drop a table

How to Drop a Table

SQL Tutorial Home

SQL SELECT Statement
SQL ORDER BY and SQL LIMIT
Using SQL WHERE Clause With Comparison Operators
Using Logical Operators in WHERE clause
SQL BETWEEN and SQL LIKE in WHERE Clause
SQL IS NULL Operator in WHERE Clause
SQL Data Types
SQL CASE Clause in SQL Queries

SQL GROUP BY Clause in a SELECT Query
Aggregate Functions in SQL
SQL Having Clause
SQL Subqueries: The Super Powerful SQL Feature
SQL DISTINCT Clause
SQL Date and Time Functions and Data Types
SQL String Functions

SQL Correlated Subqueries Increase the Power of SQL
SQL Window Functions
SQL Window Function Examples
Selecting Data From Multiple Tables: SQL JOINS
Visual Representation of SQL JOINS
Query Optimization
SQL Indexes

1. Basics
How to Compare Arrays in PostgreSQL
How to Concatenate Strings in PostgreSQL
How to Convert the Case of a String
How to Create an Array
How to Insert Array Data Into a Table
How to Insert Data Into an Array
How to Modify Arrays
How to Query Arrays
How to Replace Substrings
How to Trim Strings
How to Use string_agg()
How to Use substring()
How to Use substring() with Regular Expressions
How to Insert
How to Update
How to Delete
2. Database Management
How to Create a Table
How to Drop a Table
How to Rename a Table
How to Truncate a Table
How to Duplicate a Table
How to Add a Column
How to Drop a Column
How to Rename a Column
How to Add a Default Value to a Column
How to Remove a Default Value From a Column
How to Add a Not Null Constraint
How to Remove a Not Null Constraint
How to Create an Index
How to Drop an Index
How to Create a View
How to Drop a View
How to Alter Sequence
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Use BETWEEN Correctly
How to Query Date and Time
How to Group by Time
How to Round Timestamps
How to Convert Local Time to UTC
4. Analysis
How to Use Lateral Joins
How to Use nullif()
How to Get the First Row per Group
How to Use generate_series to Avoid Gaps In Data
How to Do Type Casting
How to Write a Common Table Expression
How to Import a CSV
How to Compare Two Values When One Is Null
How to Use Coalesce
How to Write a Case Statement
How to Query a JSON Column
How to Use Filter Clause to Have Multiple Counts
How to Calculate Cumulative Sum-Running Total

1. Basics
How to Concatenate Strings in MS-SQL Server
How to Convert the Case of a String
How to replace a Substring in a String
How to Trim Strings
How to Use string_agg()
How to Use substring()
How to Insert
How to Update
How to Delete
2. Database Management
How to Create a Table in MS-SQL
How to Drop a Table in MS-SQL
How to Rename a Table in MS-SQL
How to Truncate a Table in MS-SQL
How to Duplicate a Table in MS-SQL
How to Add a Column in MS-SQL
How to Drop a Column in MS-SQL
How to Rename a Column in MS-SQL
How to Add a Default Value to a Column in MS-SQL
How to Remove a Default Value From a Column in MS-SQL
How to Add a Not Null Constraint in MS-SQL
How to Remove a Not Null Constraint in MS-SQL
How to Create an Index in MS-SQL
How to Drop an Index in MS-SQL
How to Create a View in MS-SQL
How to Drop a View in MS-SQL
How to Alter Sequence in MS-SQL
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Use BETWEEN Correctly
How to Query Date and Time in MS-SQL
How to Group by Time
How to Extract a Component From a Datetime
4. Analysis
How to Use Lateral Joins
How to Use nullif()
How to Get the First Row per Group
How to Do Type Casting in MS-SQL
How to Write a Common Table Expression
How to Import a CSV
How to Use Coalesce
How to Write a Case Statement
How to Query a JSON Column
How to Calculate Cumulative Sum-Running Total

1. Basics
How to Concatenate Strings in MySQL
How to Convert the Case of a String
How to replace a Substring in a String
How to Trim a String
How to use group_concat()
How to do you Use a substring()
How to Use substring() with Regular Expressions
How to use insert into statement
How to use Update statement in SQL
How to use Delete SQL Statement
2. Database Management
How to Create a Table in MySQL
How to Drop a Table in MySQL
How to Rename a Table in MySQL
How to Truncate a Table in MySQL
How to Duplicate a Table in MySQL
How to Add a Column in MySQL
How to Drop a Column in MySQL
How to Rename a Column in MySQL
How to Add a Default Value to a Column in MySQL
How to Remove a Default Value From a Column in MySQL
How to Add a Not Null Constraint in MySQL
How to Remove a Not Null Constraint in MySQL
How to Create an Index in MySQL
How to Drop an Index in MySQL
How to Create a View in MySQL
How to Drop a View in MySQL
How to Alter Sequence in MySQL
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Use BETWEEN Correctly
How to Query Date and Time in MySQL
How to Group by Time
How to Round Timestamps
4. Analysis
How to Use nullif()
How to Get the First Row per Group
How to Do Type Casting in MySQL
How to Write a Common Table Expression
How to Import a CSV
How to Use Coalesce
How to Write a Case Statement
How to Query a JSON Column
How to Calculate Cumulative Sum-Running Total

1. Basics
How to Concatenate Strings in Oracle
How to Convert the Case of a String
How to Replace Substrings
How to Trim Strings
How to Use listagg()
How to Use substring()
How to Use substring() with Regular Expressions
How to Insert
How to Update
How to Delete
2. Database Management
How to Create a Table
How to Drop a Table
How to Rename a Table
How to Truncate a Table
How to Duplicate a Table
How to Add a Column
How to Drop a Column
How to Rename a Column
How to Add a Default Value to a Column
How to Remove a Default Value From a Column
How to Add a Not Null Constraint
How to Remove a Not Null Constraint
How to Create an Index
How to Drop an Index
How to Create a View
How to Drop a View
How to Alter Sequence
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Use BETWEEN Correctly
How to Query Date and Time
How to Group by Time
How to Round Timestamps
4. Analysis
How to Use nullif()
How to Get the First Row per Group
How to Do Type Casting
How to Write a Common Table Expression
How to Import a CSV
How to Use Coalesce
How to Write a Case Statement
How to Query a JSON Column
How to Use Filter Clause to Have Multiple Counts
How to Calculate Cumulative Sum-Running Total

1. Basics
How to Concatenate Strings in BigQuery
How to Convert the Case of a String
How to replace a Substring in a String
How to Trim a String
How to Use string_agg()
How to use substring() function
How to Use substring() with Regular Expressions
How to Use BETWEEN Correctly
How to use insert into statement
How to use Update statement in SQL
How to use Delete SQL Statement
2. Database Management
How to Create a Database in BigQuery
How to Create a Table in BigQuery
How to Drop a Table in BigQuery
How to Rename a Table in BigQuery
How to Truncate Table in BigQuery
How to Duplicate a Table in BigQuery
How to Add a Column in BigQuery
How to Drop a Column in BigQuery
How to Add a Default Value to a Column in BigQuery
How to Add a Not Null Constraint in BigQuery
How to Remove a Not Null Constraint in BigQuery
How to Create a View in BigQuery
How to Drop a View in BigQuery
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Query Date and Time
How to Group by Time
How to Round Timestamps
4. Analysis
How to Use nullif()
How to Get the First Row per Group
How to Do Type Casting
How to Write a Common Table Expression
How to Compare Two Values When One Is Null
How to Use Coalesce
How to Write a Case Statement
How to Calculate Cumulative Sum-Running Total

To drop a table, just do:

drop table employee;

How to Create a Table

How to Rename a Table

IN THIS PAGE

Sign up for a forever free account!

Connect to leading SQL databases

Connect to leading SQL databases

Build visual data models without learning a new language

Build visual data models without learning a new language

Create two dashboards and ten reports for free

Create two dashboards and ten reports for free

Sign up for free

Connect to leading SQL databases

Connect to leading SQL databases

Build visual data models without learning a new language

Build visual data models without learning a new language

Create two dashboards and ten reports for free

Create two dashboards and ten reports for free

Sign up for free

Platform

Business Intelligence
Embedded Analytics
Professional Services
Security
Pricing

Features

bipp Data Modeling Layer
Visual SQL Data Explorer
Data Visualization
Git-based Version Control
In-Database
SQL Editor
Scheduled Delivery and Alerts
Real-Time BI

Resources

Blog
Reports
Release Notes
Community
Migrate from Chartio
Compare

Learn

Documentation
bipp Tutorial
Why bipp?
SQL Tutorial
Definitions

Company

About
Meet The Team
Careers
News
Case studies
Disclosure
Privacy
Terms

Connect

Request Demo
Support
Contact Us

© 2022 bipp Inc.