Rene,
In the EM change format of the field and click 'Save Change Script button". Save script and don't apply changes to the table. You can run created scripts any time you want.
If you take a look at the script generated, you'll see that it's not a simple ALTER TABLE command.
>
>I have a column with identity as follows:
>
>create table mytable
> (
> nuid int default 1 identity(1,1) NOT NULL,
> cdescript varchar(50) default '' not null
> )
>
>I want to alter the column nuid to Numeric(16,0) with identity(1,1) and retain other column definition such as default and etc.
>The value for nuid already reach the limit for integer data type.
>I know that I can alter it using Enterprise Manager but I want to do it in scripts because I have 162 tables with identity column. I want to run the script in the off hours. If I will do it in the enterprise manger i will do it in every table and it will take my time to wait until the process of changing the field nuid definition. Some of my table already more than 100 million records. So it takes time to alter the column.
>
>I have try it using alter table alter column nuid numeric(16,0) idenity(1,1).....
>But it gives me syntax error.
>
>>
--sb--