Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Deleting column SQL 6.5
0 views
Skip to first unread message
Tomasz Kopacz
Jul 31, 1999, 3:00:00 AM7/31/99
to
How can I delete column from table?
I know, that I could make another table, copy all columns without that one
and then drop old table and rename new one.
But with big table it takes long time....
Maybe faster method?
--
Pozdrawiam, Tomasz Kopacz
tko...@idg.com.pl
I know, that I could make another table, copy all columns without that one
and then drop old table and rename new one.
But with big table it takes long time....
Maybe faster method?
--
Pozdrawiam, Tomasz Kopacz
tko...@idg.com.pl
BPMargolin
Jul 31, 1999, 3:00:00 AM7/31/99
to
Tomasz,
Sorry, but with SQL Server 6.5 the methodology you have outlined is
effectively your only option.
If you upgrade to SQL Server 7.0, you can use the ALTER TABLE ... DROP
COLUMN command, which will save you some time and steps, but on a very large
table might still take longer than you would like.
BTW, remember to script out indexes and triggers, as they will be dropped
along with the old table.
Tomasz Kopacz <tko...@usun.mnie.idg.com.pl> wrote in message
news:7nvl6f$9cb$1...@sunsite.icm.edu.pl...
0 new messages