Re: Portable way to DROP a COLUMN?..

Mikhail Teterin wrote:

> What's a portable application to do? Is there a syntax, that's acceptable to
> both servers? Thanks!

I don't think it matters whether there exists some universal syntax for this particular operation, because you'll always be able to find some product that doesn't support it, and you'll always find some operation where these two products require different syntax.

In addition, you will probably run into performance issues -- what might be the best way to perform some operation in one product is unacceptably slow in some other product.

The solution is to abstract away the differences, and provide a layer in your software that knows the right "dialect" for whatever db the app happens to be connected to.

Larry Coon
University of California

[And you really want your app to be deleting columns? Unless you're writing a DBA tool like dbArtisan, this seems to be a pretty odd thing for an application to be doing....] Received on Thu Sep 21 2006 - 13:11:21 CDT