Re: how can I drop a column from a table??? Hurry up, please
From: Darren K. Cockrel <derwoud_at_bellsouth.net>
Date: 1998/09/16
Message-ID: <MUGL1.359$Bi7.1154784_at_news2.atl.bellsouth.net>#1/1
Date: 1998/09/16
Message-ID: <MUGL1.359$Bi7.1154784_at_news2.atl.bellsouth.net>#1/1
This is a cheap way to do this, but it works for me. I go to schema manager,
right click on the table and choose the "create like" option. Click "Show
SQL" then copy out the SQL and make your changes in a text editor and
reapply the empty table, indexes, keys, and grants. There are some scripts
to get this script easily but I mostly use the Enterprise Manger tools and a
freeware tool called TOAD (www.toadsoft.com).
Darren
Jorge wrote in message <6tld3u$30c$1_at_talia.mad.ibernet.es>...
>Hi, and please tell me, how can I drop a column from a table???
>
>
Received on Wed Sep 16 1998 - 00:00:00 CEST