Alter Column Help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: PhilipL (anonymous_at_discussions.microsoft.com)
Date: 04/02/04

Next message: Don Hackman: "DTS Analysis Processing Task"
Previous message: Roy Goldhammer: "Re: Running DTS Package"
Next in thread: PhilipL: "Alter Column Help"
Reply: PhilipL: "Alter Column Help"
Messages sorted by: [ date ] [ thread ]

Date: Fri, 2 Apr 2004 10:59:12 -0800

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
-----------------------------------------------------------

Next message: Don Hackman: "DTS Analysis Processing Task"
Previous message: Roy Goldhammer: "Re: Running DTS Package"
Next in thread: PhilipL: "Alter Column Help"
Reply: PhilipL: "Alter Column Help"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Alter Column Help
... My alter column code fails ... I don`t know what I am missing here. ... >a primary key and all I want to do is make it an ... >ALTER COLUMN History_ID integer IDENTITYNOT NULL ...
(microsoft.public.sqlserver.dts)
Alter Column help
... My alter column code fails ... I don`t know what I am missing here. ... a primary key and all I want to do is make it an identity ... ALTER COLUMN History_ID integer IDENTITYNOT NULL ...
(microsoft.public.sqlserver.programming)
SQL 2000 not for replication
... is there a way to set "not for replication" flag on ... defined as identity and primary key, to N number of tables using sql script. ...
(microsoft.public.sqlserver.replication)
alter column
... I want to alter column that it's part of primary key. ... Before i run this script, ... The object 'PK_table1' is dependent on column 'column1'. ...
(microsoft.public.sqlserver.programming)