SYSOBJECTS case sensitive

[awolfe@m]

I generated a script for MSSQL and tried to run it in a case-sensitive database, but the script failed while trying to drop tables before creating them.  The code for dropping a table if it exists tries to look in dbo.SYSOBJECTS (upper case), which doesn't exist.  The code for other types of objects, such as foreign keys, properly looks in dbo.sysobjects (lower case).

Is there a way to change the script template to set the case correctly?

Thanks,

Andy

[hd]

There are no DDL script templates.

Report this as a bug using the Report a Bug link below...