Board index » delphi » Dropping an Recreating a column in MS SQL 6.5

Dropping an Recreating a column in MS SQL 6.5

How would you drop a column and recreate it as another name with another
data type?

Thanks

Rkr

--
                   \|||/
                   /'^'\
                  ( 0 0 )
--------------oOOO--(_)--OOOo--------------
. Reid Roman                              .
. Delphi Programmer / Analyst             .
. TVisualBasic:=class(None);              .
. May the Source be With You              .
-------------------------------------------
. Auto-By-Tel (http://www.autobytel.com)  .
. Irvine, CA U.S.A                        .
. E-Mail : rkroman (at) pacbell (dot) net .
. or reidr (at) autobytel (dot) com       .
-------------------------------------------

 

Re:Dropping an Recreating a column in MS SQL 6.5


Create another table with a new field type, then export your data to the new
table.

MSSQL don't drop colunm.

Jean Ferreira
======================
Technology Consultant
Borland Developer Certified in Delphi

Quote
Reid Roman wrote in message <3556F60D.11B9D...@pacbell.net>...
>How would you drop a column and recreate it as another name with another
>data type?

>Thanks

>Rkr

>--
>                   \|||/
>                   /'^'\
>                  ( 0 0 )
>--------------oOOO--(_)--OOOo--------------
>. Reid Roman           .
>. Delphi Programmer / Analyst           .
>. TVisualBasic:=class(None);           .
>. May the Source be With You   .
>-------------------------------------------
>. Auto-By-Tel (http://www.autobytel.com)  .
>. Irvine, CA U.S.A   .
>. E-Mail : rkroman (at) pacbell (dot) net .
>. or reidr (at) autobytel (dot) com   .
>-------------------------------------------

Other Threads