I have used SQL server management studio to generate a script to drop my database tables
But when I run the script via a 3rd party JDBC tool, although the script appears to run, nothing happens, the tables are not dropped.
the script contains a series of statements like :
DROP TABLE [PRODUCERSCH].[DEPARTMENTS]
DROP TABLE [PRODUCERSCH].[CUSTOMERS]
I am new to SQL Server. Is there some trick to running scripts generated this way via JDBC?
I have no problems using same tool with oracle scripts
I think it may need semi colons at the end of each line.. is there a way to generate these?.
SQL server version is 2012