Deleting a column from Table 1

[PureNSimple]

Well I add a column to a table by using ALTER table command. Now I want this column to be removed. This column does not contain any data. Tell me how to do this???

 

[Faust]

Use the SELECT INTO command to select only the column you want from the source table INTO the new table. You can even reorganize the sequence of the columns this way. After, drop the source table and sp_rename the new table or do another SELECT INTO the original name from that new table.<br>
<br>
You can also use this way to insert a new column "in between" existing column, like:<br>
<br>
SELECT Ca, Cb, Cc, "MyNewCol"=convert(varchar(20)), Cd INTO MyNEWTable<br>
FROM MyCURRENTTable<br>
<br>
Hope this help.<br>
<br>
Sylvain Faust<br>
President<br>
Sylvain Faust Intl (SFI)<br>
880 boul. de la Carriere, Suite 130<br>
Hull, Quebec, Canada J8Y 6T5<br>
<br>
SQL-Programmer 2.VIII:<br>
"The best SQL integrated development environment we've seen, earning<br>
PC Week Labs' Analyst's Choice honors." [Oct. 26, 1998]<br>

http://www.zdnet.com/pcweek/stories/news/0,4153,363685,00.html<br>

<br>
Tel: (819) 778-5045, Ext. 804<br>
Toll Free: 1-800-567-9127 (U.S. and Canada only)<br>
Fax: (819) 778-7943 International; (617) 722-9389 U.S. only<br>
Email: sfaust@sfi-software.com<br>
<br>
Sylvain Faust Inc. (SFI)<br>
Delivering SQL Solutions, Since 1988<br>

http://www.sfi-software.com<br>

<br>
To receive news bulletins from SFI automatically, just send a blank email to:<br>
SFI-NEWS-SUBSCRIBE-REQUEST@peach.ease.lsoft.com<br>
<br>
SFI Online Store:<br>

http://store.sfi-software.com<br>

<br>