Is there a way to find out if a column exists in a table.

I am trying a statement like this

If column does not exist then

alter table etc...

I'm doing it right now with try except but there has to be a cleaner way.

Michael,

<< Is there a way to find out if a column exists in a table. >>

Use a query on the Information schema table TableColumns:

SQLString:='SELECT * FROM Information.TableColumns '+
                  'WHERE TableName=''MyTable'' AND Name=''MyColumn''';

if (MyEDBDatabase.Execute(SQLString)=0) then
  // Execute ALTER TABLE

http://www.elevatesoft.com/edb1sql_tablecolumns_table.htm
http://www.elevatesoft.com/edb1d7_querying_database_objects.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


When is EXISTS likely to make a reappearance?

Roy Lambert

Roy,

<< When is EXISTS likely to make a reappearance? >>

I'm not sure if it is yet, but I'll look into it further here as I move
along with 1.06.

--
Tim Young
Elevate Software
www.elevatesoft.com