sql newb - creating tables

[hanan98]

I have data
Customer(Cust_id, Cust_fname, Cust_lname, Phone_area_code, Cust_phone, Cust_balance)

and want to create it in sql with Cust_id as the primary key.

I came up with this.

Create collection assignment2
Create table assignment2.customer (cust_id char (10 ) not null with default, cust_fname char (10 ) not null with default, cust_lname char (10 ) not null with default, phone_area_code char (3 ) not null with default, cust_phone char (7 ) not null with default, cust_balance char (10 ) not null with default, constraint assignment2.cust_id_pk primary key (cust_id))
Table customer created in assignment2



am I on the right track?

 

[r937]

which database system are you using? this is the ANSI SQL forum

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[alapatis]

u can use alter table command to set primary key to Cust_id
iff the field has no duplicate data