Re: [GENERAL] Redefining an existing Table Schema for Foreign Key Constraint - Question

2008-11-07 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Michelle Konzack <[EMAIL PROTECTED]> writes: > Hallo Harald, > Am 2008-11-03 13:41:52, schrieb Harald Fuchs: >> In article <[EMAIL PROTECTED]>, >> Brian714 <[EMAIL PROTECTED]> writes: >> > Customers Table >> > id:integer -- primary key >> > first_name:varchar(50) >>

Re: [GENERAL] Redefining an existing Table Schema for Foreign Key Constraint - Question

2008-11-07 Thread Michelle Konzack
Hallo Harald, Am 2008-11-03 13:41:52, schrieb Harald Fuchs: > In article <[EMAIL PROTECTED]>, > Brian714 <[EMAIL PROTECTED]> writes: > > Customers Table > > id:integer -- primary key > > first_name:varchar(50) > > last_name:varchar(50) > > cc_id:integer references Creditcards.id > > address:varcha

Re: [GENERAL] Redefining an existing Table Schema for Foreign Key Constraint - Question

2008-11-03 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Brian714 <[EMAIL PROTECTED]> writes: > Currently, the database contains thousands of records in the Customers and > Creditcards tables. I would like to re-define the Customers table to follow > the following schema: > Customers Table > id:integer -- primary key > f