RE: [ADMIN] Adding columns to existing tables

2001-05-09 Thread John Pagakis
DevelopOnline.com 480.377.6828 -Original Message- From: Stephan Szabo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 9:01 AM To: John Pagakis Cc: '[EMAIL PROTECTED]' Subject: Re: [ADMIN] Adding columns to existing tables On Tue, 8 May 2001, John Pagakis wrote: > I

Re: [ADMIN] Adding columns to existing tables

2001-05-09 Thread Stephan Szabo
On Tue, 8 May 2001, John Pagakis wrote: > I have a table - suppose it is called company: > > CREATE TABLE ( company_id char(36) NOT NULL UNIQUE PRIMARY KEY, > . > . > . > ); > > I want to add the following field: >

[ADMIN] Adding columns to existing tables

2001-05-08 Thread John Pagakis
I have a table - suppose it is called company: CREATE TABLE ( company_id char(36) NOT NULL UNIQUE PRIMARY KEY, . . . ); I want to add the following field: company_nemonic char( 3 ) NOT NULL UNIQUE We