Subject Re: [firebird-support] Newbie: A few questions...
Author Martijn Tonies
Hi,

> 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'?)

No, you cannot.

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

No, sort orders are on a per-index basis. Primary, unique and Foreign
key auto-created indices are ASC only.

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

256 bytes, not affected by the datababase page size in their current
versions.

With regards,

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