Alter Column Help

#1

Any help is appreciated here. My alter column code fails
below. I don`t know what I am missing here. The column is
a primary key and all I want to do is make it an identity
column. Thanks for any idea.

Phlip
-----------------------------------------------------------
ALTER TABLE dbo.HISTORY
ALTER COLUMN History_ID integer IDENTITY(1,1) NOT NULL
-----------------------------------------------------------

#2

Quote:

-----Original Message-----
Any help is appreciated here. My alter column code fails
below. I don`t know what I am missing here. The column
is
a primary key and all I want to do is make it an
identity
column. Thanks for any idea.

Phlip
---------------------------------------------------------
--
ALTER TABLE dbo.HISTORY
ALTER COLUMN History_ID integer IDENTITY(1,1) NOT NULL
---------------------------------------------------------
--

.

Sorry, wrong newsgroup.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Alter Column Help

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Alter Column Help - 04-02-2004 , 01:59 PM

Alter Column Help - 04-02-2004 , 09:59 PM