Naresh Chandak wrote :
>HI
> can i give sequence as defualt?
> I am inserting rows via insert statment
> I was wondering if it were possible to set up the "default" value for a
>field to get icreamental value( as identity field in sql server or DEFAULT
>NEXTVAL("seq name") in Post grace sql ).
You can use default SERIAL for your field. Example :
CREATE TABLE FOO (id fixed(20) default serial)
If you don't have any further requirements, you can use data type
serial alternatively, which stands for 'fixed(10) default serial' :
CREATE TABLE FOO (id serial)
Please note : you can have at most 1 serial field per table !
Thomas
---
Thomas Anhaus
SAPDB, SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
