Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
scottpt
Posting Yak Master
186 Posts |
Posted - 2010-04-27 : 09:31:17
|
I have a tableCREATE TABLE [dbo].[CheckItemImage]( [CheckItem_ID] [dbo].[TID] NOT NULL, [RowGUID] [dbo].[TReplicationID] ROWGUIDCOL NOT NULL, [Image_Check] [image] NULL, [Image_Back] [image] NULL, [ImageFrontRaw] [image] NULL, [ImageBackRaw] [image] NULL, [ImageFrontRawFormat] [dbo].[TShortName] NULL, [ImageBackRawFormat] [dbo].[TShortName] NULL, [Date] [datetime] NULL, CONSTRAINT [PK_CheckItemImage] PRIMARY KEY CLUSTERED ( [CheckItem_ID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]I want to alter it to .. TEXTIMAGE_ON [IMAGES].Is this possible with out dropping and recreating the table. |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2010-04-29 : 08:47:09
|
I tried this it only moves the non image columns |
|
|
|
|
|
|
|