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?
Thanks for the reply by email. I had been looking for an option to set the terminator, but yes, 'GO' worked fine.