Hi All, Is it possible to check if the certain column is existed in the table. For example : I had the table as define below: create table tablea (appid int, bytesIn int, bytesOut int)
and I want to add one more column with default value of 1 and I don't want to drop the table and recreate it again because I want to keep the data in the table. Thanks, jp ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs