Depends of the RDBMS. Some will allow via ALTER TABLE statement, but most don't support this. You will have to cretae a brand new table with the extra column, copy over all the data, delete the original. Kristofer Wolff wrote: > quick and fast: > > hi all, > > does sombody know, how i can add a col in a table of a database ?? > XBASE, SYBASE and DB2 ??? > > -- > I have a Atributes table, and the user must add artibutes, so my tables > looks like: > > *********** *********** *********** > * Prod.NR * * atr 1 * * atr 2 * > -------- --------- --------- > 1 bla blub > 2 palimm palimm > ------------------------------------ > > Know I create an Atribute 3 and want to add a col named atr 3, but I can > nothing find in the docs ! > > _______________________________________________ > Perl-Win32-Web mailing list > [EMAIL PROTECTED] > http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web -- Simon --------------------------------------- Department of Biomolecular Sciences UMIST, PO Box 88, Sackville St Manchester, M60 1QD United Kingdom Phone: +44 161 200 8912 Fax: +44 161 236 0409 Mobile: +44 776 183 0327 Email: [EMAIL PROTECTED] --------------------------------------- _______________________________________________ Perl-Win32-Web mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web
