Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Drop Column

0 views
Skip to first unread message

Stefan Küsters

unread,
Oct 2, 1998, 3:00:00 AM10/2/98
to
Hi,
is there a way to drop a column in a table?

Thanks,
Stefan


Neil Pike

unread,
Oct 3, 1998, 3:00:00 AM10/3/98
to
Stefan,

Q. How can I add/amend/delete columns?
(v1.0 25.09.1998)

A. Under SQL 7.0 all the above are easily done with the gui or
supplied stored-procedures.

With SQL 6.5 and below it is only possible to ADD a nullable column.
For any other change a new table must be created, the data copied
across, and the tables renamed around.

Certain 3rd party tools provide a gui interface to do this, that makes
it look transparent, however they are really doing all the work
described above, so if you make the change to a large table it will
take a long time to do the work.

Examples of tools are Microsoft's Visual Database Tools (part of Visual
Interdev) and SFI's SQL Programmer.

Neil Pike MVP/MCSE
Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated
otherwise)


0 new messages