Why table name schema is so important for you? Can you name a table somehow else, and if you need class named Schema, then specify a javaName="Schema" in your my-schema.xml.
Regards, Kostya
Alexandru Dovlecel wrote:
Hi all,
Pls need help ASAP. I have a database that contains tables that are reserved words for mssql. E.g. one table is called SCHEMA. When I generate the code from my-schema.xml, it generates the my-schema.sql file. When running the sql file in the mssql I get an error: SCHEMA keyword not expected after CREATE TABLE (or something like this). I can do this by generating CREATE TABLE [SCHEMA]. But if I put the table name as "[SCHEMA]" then the primary key triggers are not correct (e.g. [SCHEMA]_PK is not a valid name).
How can I overcome this problem? Does anyone have some patched mssql templates for generating the sql and the OM classes?
Any suggestions? Pls help.
Thanks alot, Alex
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
