Import SQL Error - statement terminator for the last SQL statement.

Hi,

I am trying to create a table by importing a piece of SQL in ER/Studio 17.0.  I'm getting the error 'The SQL parser reached the end of the file without finding a statement terminator for the last SQL statement'.  I've tried various options like 'Physical Parser'.  The DB choice is set to MSSQL 2016.

My test SQL is trivial:

CREATE TABLE Test(ClientRowID INT);

but still get the error.  I can get around it by actually creating the table in the DB and then reverse engineering it, but why wouldn't the Import SQL route work?

Steve

Parents
No Data
Reply Children
No Data