SQL Server 2016 CTP3.1 — that new to the developer?
2 years, 1 month ago
Until recently in my memory the announcement of SQL Server 2016 which was personally presented by Satya Nadella was postponed. And suddenly, suddenly, steel one behind one to leave fresh Community Technology Preview (at the moment the freshest version – CTP3.1). In process of acquaintance to the new version, there was a wish to share impressions more and more …
Further overview of new syntax counters of new SQL Server 2016.
#1 – DROP IF EXISTS
CREATE TABLE dbo.tbl (
a INT, b INT,
CONSTRAINT ck CHECK (a > 1),
INDEX ix CLUSTERED (a)
If earlier before removal of object it was necessary to do check:
IF OBJECT_ID(N'dbo.tbl', 'U') IS NOT NULL
DROP TABLE dbo.tbl
That more compact syntax appeared now:
DROP TABLE IF EXISTS dbo.tbl
Read more »