Sets the identity column to int, smallint, tinyint, or numeric.
create table [database .[owner ].]table_name (column_name datatype
[default {constant_expression | user | null}]
(id int | smallint | tinyint | numeric(n) }
{[{identity | null | not null}]
[off row | [ in row [ (size_in_bytes) ] ]
............)
id – the identity column is set as integer or numeric
create table...... id(int)
The System Administrator, Database Administrator and Table Owner use this clause when creating a table.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
