How to write DROP TABLE in different databases

How to write DROP TABLE in different databases

How to write DROP TABLE in different databases

1.MySql

DROP TABLE IF EXISTS [table_name]

2. In Oracle:

BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE [table_name]';
  EXCEPTION WHEN OTHERS THEN NULL;
END;

3. In Sql Server

IF EXISTS (
  SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
  WHERE TABLE_NAME = '[table_name]')
DROP TABLE [table_name]

Thank you for reading, I hope it can help you, thank you for your support of this site!

<<:  Detailed steps to install Anaconda on Linux (Ubuntu 18.04)

>>:  How to implement responsive layout in vue-cli

Recommend

MySQL 5.5.56 version (binary package installation) custom installation path step record

Installation path: /application/mysql-5.5.56 1. P...

Design Theory: Textual Expression and Usability

<br />In text design, we usually focus on th...

A solution to the abnormal exit of Tomcat caused by semaphore

I'm playing with big data recently. A friend ...

Analysis of the difference between bold <b> and <strong>

All of us webmasters know that when optimizing a ...

Implementing search box function with search icon based on html css

Preface Let me share with you how to make a searc...

How to redraw Button as a circle in XAML

When using XAML layout, sometimes in order to make...

Let you understand how HTML and resources are loaded

All content in this blog is licensed under Creati...

Docker data volume container creation and usage analysis

A data volume container is a container specifical...

How to create a MySQL database (de1) using commands

1. Connect to MYSQL Format: mysql -h host address...

Example of creating table statements for user Scott in MySQL version of Oracle

Overview: Oracle scott user has four tables, whic...

Detailed explanation of the solution to the Baidu https authentication prompt "Please redirect your http site 301 to the https site"

I recently wanted to convert a website to https a...

ElementUI implements cascading selector

This article example shares the specific code of ...

Solution for importing more data from MySQL into Hive

Original derivative command: bin/sqoop import -co...

MySQL DML language operation example

Additional explanation, foreign keys: Do not use ...

Comparison of div and span in HTML_PowerNode Java Academy

1. <div></div> and <span></s...