Try Select count(*) into vcolcount Indic iv1 from sys_colums where syscolumn = .vcol
Do the same for table from sys_tables Buddy Sent from my iPhone > On Jan 31, 2015, at 10:23 AM, TOM HART <[email protected]> wrote: > > I an update routine to update my database and want to know if there is a way > to check if a column and/or table exists, so I can include this in my > updating routine. I know chkfile will check for a file but is there > something similar for table or column > > Tom Hart
