When using SQLcl with Oracle Database, you can export your query results to a JSON file with the SPOOL command.
Here are four ways to check whether or not a table exists in a MariaDB database.
Below are five ways to check if a table exists in a PostgreSQL database.
Below are four ways to list out the views in a MySQL database using SQL or the command line.
There are several ways to show a list of databases in SQL Server. Probably the easiest way is to use the sp_databases stored procedure.
The sp_databases stored procedure is a kind of SQL Server equivalent to the SHOW DATABASES command that can be used with DBMSs such as MySQL and MariaDB. OK, maybe they aren’t strictly equivalents, but based on their ease of use, they could be viewed as such from a user’s perspective.
In MariaDB, you can use the IF NOT EXISTS clause of the CREATE TABLE statement to check whether or not a table of the same name already exists in the database before creating it.
The table will only be created if there isn’t already one with the same name.
In MariaDB, we can query the information_schema.tables table to check the size of a database.
This table returns information about the tables and views in each database on the server. We can group the results and return the aggregate amounts for each database.
In PostgreSQL, you can use the IF NOT EXISTS clause of the CREATE TABLE statement to check whether or not a table of the same name already exists in the database before creating it.
The table will only be created if no other table exists with the same name. If a table already exists with that name, a “notice” will be issued instead of an error.