how to search for a table with name “yyyyy” in dbeaver postgress using Query

You can execute the following SQL query in the SQL editor of DBeaver to check if a table named yyyyy exists:

SELECT table_schema, table_name
FROM information_schema.tables
WHERE table_name = 'yyyyy';

Leave a comment

Your email address will not be published. Required fields are marked *