Adding columns to a table

[woodyinoz]

Hi all,

I'm looking for some SQL code that will add some additional fields to an existing table. I'm using SQLTalk to interact with my SQLBase Server 7.6.1.

Can anyone suggest anything?

Thanks in advance,

Woody.

 

[nigelrivett]

alter table tblname add mycol varchar(10) null

but see

http://www.nigelrivett.net/AlterTableProblems.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.