Hi Guys,
Its just not clicking for me.
Given column "Cust_Ref" from table Jobtickets is currently VARCHAR(12).  What's the correct syntax to change it to VARCHAR(20) using SQLs Alter Table/Alter Column?

Regards & TIA,
Ian

Ian


I'm going to use the "teach a man to fish" approach here.

Go into EDBManager, open the session & database, select the table and select Alter Table

Make the alterations in there (I'm assuming you know how to do that)

Then (and this is the important bit) - from EDBManager's menu select Explorer | SQL History

The SQL command needed to make the table alteration will be sitting there.

Pretty much all of the menu commands are reflected in there. Its only the trivial stuff like opening a session or database that isn't.

Remember this because its one of the best learning mechanisms and will prevent you from having to ask questions and wait for the answer.

Roy Lambert

Hi Roy,
Ahhhh!   That SQL History thing again.  I looked at the SQL tab on the main screen.
Just not used to that facility/functionality.

Thank you for the pointer/reminder.

Regards,
Ian