SYS_COLUMN_NAME
From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Saturday, January 31, 2015 7:44 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Finding columns/tables It may be sys_col_name. If vcolcount = 0 then col does not exist Sent from my iPhone On Jan 31, 2015, at 10:33 AM, Buddy Walker <[email protected] <mailto:[email protected]> > wrote: 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] <mailto:[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
