sql newb - creating tables
sql newb - creating tables
(OP)
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?
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?
RE: sql newb - creating tables
r937.com | rudy.ca
Buy my new book Simply SQL from Amazon
RE: sql newb - creating tables
iff the field has no duplicate data