Subject RE: [firebird-support] Newbie: A few questions...
Author Johan van Zyl
2. "mixed sort orders?"
Apparently not

Johan van Zyl
JVZ Systems CC
Somerset West
-----Original Message-----
From: lesdean79 [mailto:LesDean79@...]
Sent: 06 August 2004 10:59
Subject: [firebird-support] Newbie: A few questions...

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

Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.734 / Virus Database: 488 - Release Date: 2004/08/04

[Non-text portions of this message have been removed]