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

Microsoft SQL Server will be available for Linux in 2017

Deutsch Microsoft has officially announced that their database MS SQL Server will become available for Linux in 2017. I think the time has come for this. Since the departure of Steve Ballmer Microsoft has become a little bit less religous and more pragmatic. There are good reasons to be skeptical about companies like Microsoft and …

Share Button