Checking if column exist by code

• Corobori

  Ten Centuries

  Points: 1316

  More actions

  July 14, 2004 at 1:44 pm

  #85852

  I developped an application running as a standalone running MSDE SQL Server which has been installed on several PCs. We had to do some changes in the data structure and would like that when the application starts 1) Checking if some columns exists in database 2) If they don't create them.

  Is it a good practice ? How do you handle database structure change ?

  
  Jean-Luc
  www.corobori.com
  

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  July 14, 2004 at 1:52 pm

  #514544

  I don't like to do this in code, but if you must, query the information_Schema.columns view for the table and column.