On Wednesday 24 October 2001 15:57, you wrote:

> Hi,
> I'm creating tables for the first time with interbase 6 and need to
> know the table description function - equivalent to desc
> <tablename>; of MySQL/Oracle which prints a layout/description of
> each column in the table.
>
> And also the easiest way to automatically generate incremented column
> ids for new rows inserted into a table. (Equivalent of creating the
> column as 'auto_increment' with mysql).
>
> Does anyone know?

Hi,

try this:

show database;
and
show table YOURTABLENAME;

you can also type help; in console (isql) to see more options.

yves

> Dave
>
> _____________________________________________________________________
>__ Never pay another Internet phone bill!
> Freeserve AnyTime, for all the Internet access you want, day and
> night, only £12.99 per month. Sign-up at
> http://www.freeserve.com/time/anytime
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Pinpoint the right security solution for
> your company- Learn how to add 128- bit encryption and to
> authenticate your web site with VeriSign's FREE guide!
> http://us.click.yahoo.com/yQix2C/33_CAA/yigFAA/dpFolB/TM
> ---------------------------------------------------------------------
>~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/

--
(Note: new email address: yg@...)

Linux 2.4.13 #2 Wed Oct 24 18:31:56 CEST 2001 i686
9:18pm up 3:32, 1 user, load average: 0.22, 0.09, 0.12