ALTER COLUMN to for INDENTIY?

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

From: dwa (da_at_hotmail.com)
Date: 03/19/04 

Date: Fri, 19 Mar 2004 16:32:24 -0500

Is it possible to ALTER COLUMN to convert a column into an IDENTIY column,
from a script?

(I know you can do this from Enterprise Manager - that doesn't help)

So far, eveything I've seen on this says "NO"

Can anyone confirm this for certain?

If it IS possible... how? I can locate at docs that are helpful.

Thanks,

-- dwa

Relevant Pages

  • Re: ALTER TABLE: recreate columns
    ... change script" toolbar button. ... Enterprise Manager does not always do things efficiently - most of it ... >"Specifies whether the column can accept null values. ... >specified in ALTER COLUMN only if the column contains no null values. ...
    (microsoft.public.sqlserver.programming)
  • Re: ALTER IDENTITY setting...
    ... Enterprise manager will create a new table and drop the old one. ... it to generate the script to do this. ... > I just need to alter column with Identity. ... >> rename the new one). ...
    (microsoft.public.sqlserver.programming)
  • Re: ALTER COLUMN to for INDENTIY?
    ... profiled Enterprise Manager you should see that it creates a new table, ... > Is it possible to ALTER COLUMN to convert a column into an IDENTIY column, ... > from a script? ...
    (microsoft.public.sqlserver.programming)
  • Re: ALTER IDENTITY setting...
    ... Enterprise Manager would do. ... I also would suggest you use EM and save the script. ... Pro SQL Server 2000 Database Design - ... > I just need to alter column with Identity. ...
    (microsoft.public.sqlserver.programming)
  • RE: Recreating a database???
    ... Unfortunately the script that Enterprise Manager produces doesn't always ... to build a database using the scripts you've created. ... record the build into a .SQL file and as the builder builds in the correct ...
    (microsoft.public.sqlserver.programming)