It can be done for SQL Server, not sure about other dbs. For SQL Server:

cn.Execute "ALTER TABLE <table name> ADD <column name> <column definition>"



regards

David Cameron

nOw.b2b

dcameron@i...



-----Original Message-----

From: Seb Burnett [mailto:s.burnett@u...]

Sent: Monday, 10 September 2001 9:40 PM

To: ASP Databases

Subject: [asp_databases] Adding and deleting datbase fields





Hi,

I was wondering if it would be possible to add and delete a field in a 

database dynamically from the webpage?



Thank you



Seb