ALTER TABLE department ADD INDEX dept_name_idx (name);
SHOW INDEX FROM department \G
ALTER TABLE department DROP INDEX dept_name_idx;
ALTER TABLE department ADD UNIQUE dept_name_index (name);
, )) fed_id, cust_type_cd, address, city, state, postal_code FROM customer;
;
SELECT cst.cust_id, cst.fed_id, bus.name FROM customer_vw cst INNER JOIN business bus ON cst.cust_id = bus.cust_id;
;