Impulse7

Impulse7

  • NA
  • 1
  • 0

Changing a Database Schema Programmatically

May 16 2005 11:32 PM
Hi guys, first post here, have read many articles, including ones that relate to my question Just wondering if there is a class or wrapper class or 3rd party control that any of you may have heard of that will allow me to change a databases schema through .NET. From what I understand, Dataset.WriteXMLSchema or .ReadXMLSchema don't actually send any changes back to the database. N e ideas on how I would do this like this [pseudo code] Open Database if(Database.GetCurrentSchema() != NewSchema) { Database.CurrentSchema = NewSchema } Database.Update() [/pseudo code] or is that impossible, do I need to do the ExecuteNonQuery("ALTER TABLE...... stuff? Thanks for the help Impulse 7

Answers (1)