🚀 go-pugleaf

On Thu, 11 Jun 1998 14:45:11 -0500, "Christopher F. Neumann"
<CNeumann@Physix.com> wrote:

>Is it me, or is it virtually impossible to use the following w/SQL Server
>6.5 database from within VdB 5.6:
>
>alter table tablename drop fieldname

Your statement appears syntactically correct. It would require a table
named TableName and a column named FieldName (yes, I know these are just
for example). Assuming you use this syntax with actual metadata names the
SQL statement should work -- assuming the database back-end supports the
syntax.

Some database systems do not support the DROP COLUMN clause of the ALTER
TABLE statement (hard to believe, but true!). Check the documentation for
Microsoft SQL Server to see whether or not it supports this. If it does
not, you would not be able to use this syntax no matter what front-end
programming tool you use: Visual dBASE, Delphi, C++Builder, Visual Basic,
or whatever.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                      "Knowledge comes, but wisdom lingers."
Technical Publications                -- Alfred, Lord Tennyson (1809-1914)
INPRISE Corporation
http://www.inprise.com/delphi