Autonumber ??

From: Gaz <gonkowonko_at_freeuk.com>
Date: 6 Nov 2002 07:23:39 -0800
Message-ID: <24cc4785.0211060723.54b13440_at_posting.google.com>

[Quoted] [Quoted] I want to set mu customer_id column to an autonumber so when data is entered into the table the id is automatically set to a number. can anyone tell me how to edit my current table to acheive this

CHEERS create table customer
( customer_id varchar2(10) PRIMARY KEY,
title varchar(4) DEFAULT 'mr' CONSTRAINT check_title CHECK(title in ('mr','miss','ms','mrs')),
surname varchar2(30),
forename varchar2(30),
address varchar2(50),
email varchar2(30),
bill_address varchar(50),
corp_cust varchar2(3) DEFAULT 'NO' CONSTRAINT check_corp_cust CHECK(corp_cust IN ('YES','NO')),
corporate_id varchar(10) REFERENCES CORPORATE(corporate_id)); Received on Wed Nov 06 2002 - 16:23:39 CET