alter table

Sets the identity column to int, smallint, tinyint, or numeric.

Syntax

alter table [[database.][owner].table_name
               { add column_name datatype
                [default {constant_expression | user | null}]
                    (id { int | smallint | tinyint | numeric(n) }
                 {identity | null | not null} ...	
	 }.
...

Parameters

id – the identity column is set as integer or numeric.

Example

alter table
        id numeric

Permissions

The System Administrator, Database Administrator and table owner use this clause when altering a table.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF