General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
>Hi all,
>
>I have a table, to which I add a column:
>
>alter table temp.dbo.tmpdumpallprs
> add dumpprsid bigint IDENTITY(1,1) NOT NULL
>
>So the column is filled with values 1 to {nr of records}. Now I want to add a constant to the column. So I have to remove the identity property. How do I do that?
Why not create a new column for the constant? Its purpose is completely different from that of a PK. A PK should be a simple thing that is controlled by the database.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only