Re: adding a column to a table

Tech-Archive recommends: Fix windows errors by optimizing your registry



On Wed, 4 Apr 2007 09:46:00 -0700, David Thielen wrote:

Hi;

Is there a way to add a column to a table, preferably not at the end, via
ADO.NET? And hopefully in a vendor independent way as I have to do this for
Sql Server, Oracle, DB2, and MySql.

Are you talking about a dataset or a physical table?

If it is a physical table you can use SQL, the alter table statement
provided you're not putting anything unusually fancy like constraints or
defaults that are database specific
--
Bits.Bytes
http://bytes.thinkersroom.com
.


Quantcast