SQL: DROP, CREATE,… How to avoid errors?

In SQL we often want to create or drop an object (TABLE, VIEW, SEQUENCE, INDEX, SYNONYM, DATABASE, USER, SCHEMA,….) Now we do not know if this thing exists or not. We would like to write scripts, that work in either case. So something like CREATE TABLE IF NOT EXISTS XYZ (…); or DROP TABLE IF …

Share Button

PostgreSQL

Almost every non trivial application uses in some way a database. For many years this has been anyway Oracle, DB2 or MS-SQL-Server, depending mostly on the habits and on the religious orientation of the organization that developed or ran the application. These days all three are available for Linux and MS-Windows. DB2 is also available …

Share Button