Sudhakar Donepudy wrote : >Could any one tell me what is the max possible value for a sequence >generator. Is it safe to use sequence generator for a primary key in a table >with some ten's of thousands of records?
>Thank you, >Sudhakar Donepudy In the documentation (create sequence statement) you find the following information : MAXVALUE Defines the largest value generated by the sequence. If no value is defined for MAXVALUE, the largest integer value that can be represented with 38 digits is used. So the maximal possible sequence value is 99999999999999999999999999999999999999. Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
