Hi, 

just use '//' : 

CREATE TABLE A ...
//
CREATE TABLE B ...
//
...

Cheers
Alexander Schr�der
SAP Labs Berlin

> -----Original Message-----
> From: Richard Damoser [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 21, 2003 1:05 PM
> To: [EMAIL PROTECTED]
> Subject: running ddl statements in batch job
> 
> 
> Hello,
> 
> I have a batch script, where I want to create some tables, one CREATE 
> statement after the other. When I run the script in SQL Studio, I 
> receive the error:
> 
> Invalid end of SQL statement
> 
> When I try to seperate the the CREATE statements with either 
> 'GO' or ';' 
> I receive the same error.
> 
> What is the correct way to do it?
> 
> Thanks in advance
> 
> Richard
> 
> 
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
> 
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to