Re: alter table rbwin65 1.858b

[randyp]

Bernie,           Check the syntax diagram.  You normally alter a table to make a change.  First you have to identify the table and column name which you want to change.  Then you specify what you want to change it to (including the column name):   ALTER TABLE tblname ALTER COLUMN colname to [COLUMN DEFINITION]   [COLUMN DEFINITION] = colname [=expression] datatype [NOT NULL]   Try:   ALTER TABLE podetail + ALTER COLUMN partNo + TO partNo TEXT 27 NOT NULL    Randy Peterson   ----- Original Message ----- From: Bernard Lis To: [EMAIL PROTECTED] Sent: Friday, September 20, 2002 12:17 PM Subject: alter table rbwin65 1.858b Alter table podetail alter partno text 27 not null gives the error  "The referenced table does not exist"   The table does exist as proved by "list podetail"   I checked the spelling very carefully.  So what's wrong here? Can anyone help?   Bernie Lis Megabytes, Inc.