Hi,

> Can I assume that all objects (tables, views, trigger, ...) are all
> upper case in system tables?

Ha, if it only was that easy.

If you created them without quotes, they're all uppercased.

If you created them like this:

CREATE TABLE "MyTable"

Then the name is mixed case.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com