With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work ...
In this example (T-SQL provided in code section), Person1 has 3 Cars assigned to them, but only 1 is active (Null EndDateTime). However, when we try to reverse engineer this database, we end up with a ...
CREATE TABLE DBA."table1" ( "code" INTEGER NOT NULL, "name" VARCHAR(40) NOT NULL, CONSTRAINT "pk_table_code" PRIMARY KEY ("code") ); CREATE TABLE DBA."table2" ( "code ...