Hi Martijn,

Thanks for the info.
--
--------------------------
Lesley Dean
CapeSoft
www.capesoft.com


--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> 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