exist a command call ALTER TABLE. this command allow add, delete fields,
indexes, primary key, etc. maybe is similar in MS SQL SERVER.

/Carlos


jwhinyyc Escribio :-)

>
>
>
>
> Using Firebird 1.0.2, Windows 2000 PRo SP3, latest versions of
> IBOConsole and IBAccess.
> Using IBOConsole, I have created a database, with 1 table which has 1
> field. I can't see how to create additional fields in that table - the
> only 'create' is for another Table.
>
> Using IBAccess, things look more promising. I can go through the
> motions of adding a new field, specify the fieldname, type (varchar)
> and maxsixe (32), but when I click 'OK' an error says "unsuccessful
> metadata update, table column not found".
>
> I would not expect it to be found, since I am currently trying to
> create it.
>
> Help, please. I seem to be missing something obvious but can't see
> what.
>
> NB previous experience with databases is somewhat limited - mostly VB
> or VB-Script with *.csv files or MS SQL-Server.
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
> ADVERTISEMENT
>
>
>
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

--
Carlos Chávez
AG Software, S.A.
776-8344
267-3007