Hi All,

Just beginning to work with FireBird. So far looks really cool. Some
questions I have run into, which you guys and gals may be able to
help me out with:

1. Can you rename a table with SQL syntax in FireBird?
(Obviously, one can create a new table, copy data across, and then
drop the old table, but is there a 'Alter table RENAME oldtablename
to newtablename'?)

2. Does FireBird support Multi-component keys with mixed sort orders?
For example 1 key, 2 fields, 1 ascending, and 1 descending?

3. What is the maximum key size in FireBird, and is it affected by
the Database Page Size?

Thanks in advance.
--
--------------------------
Lesley Dean
CapeSoft
www.capesoft.com