fieldname2 (leaving the data intact and fieldspecs the same) via a SQL
statement. I can do this in mySQL like so:
ALTER TABLE filename CHANGE fieldname1 fieldname2 varchar(10)
Would SQL Server thus be
SET NOCOUNT ON
ALTER TABLE [dbo].[filename] ALTER COLUMN [fieldname1] [fieldname2]
[nvarchar(10)] NULL
SET NOCOUNT OFF
and Oracle:
ALTER TABLE filename MODIFY ( fieldname1 fieldname2 VARCHAR2(10) )
I'm away from my test servers for the next few days and can't test the
theory. Does someone know off the top of their heads?
--Matt Robertson--
MSB Designs, Inc.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
