topic Re: If exists in databrickds sql in Data Engineering

If exists in databrickds sql

g96g — Mon, 19 Jun 2023 07:28:03 GMT

what is the equivalent of "IF EXISTS" in databricks? I would like to first check something later after that use the insert into statement.

Ajay-Pandey — Mon, 19 Jun 2023 13:54:27 GMT

Hi @Givi Salu ,

IF EXISTS - If specified, no TABLE_OR_VIEW_NOT_FOUND error is thrown when the table does not exist.

DROP TABLE IF EXISTS employeetable;

Anonymous — Tue, 20 Jun 2023 06:03:52 GMT

Hi @Givi Salu

We haven't heard from you since the last response from @Ajay Pandey , and I was checking back to see if her suggestions helped you.

Or else, If you have any solution, please share it with the community, as it can be helpful to others.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.

WWoman — Thu, 16 Nov 2023 22:39:03 GMT

Is there a way to check if a table exists, without trying to drop it? something like :

select table_name from system_catalogs where database_name = 'mydb' and schema_name = 'myschema' and object_name = 'mytab';

kottsane — Fri, 08 Dec 2023 18:06:05 GMT

You can query `system.information_schema.tables` which includes all existing tables in the metastore. More on information schema: https://docs.databricks.com/en/sql/language-manual/sql-ref-information-schema.html