fullname

User-defined type that contains two fields for first name and last name.

User-defined type that contains two fields for first name and last name.

SOURCE '0_create_keyspace.cql';

// START-drop
DROP TYPE IF EXISTS cycling.fullname;
// END-drop

// Store first and last in the same column using a custom type

// START-fullname
CREATE TYPE IF NOT EXISTS cycling.fullname (
  firstname text,
  lastname text
);
// END-fullname

// START-alt
ALTER TYPE cycling.fullname
ADD middlename text;
// END-alt

// START-rename
ALTER TYPE cycling.fullname
RENAME middlename TO middle
  AND lastname TO last
  AND firstname TO first;
// END-rename

ALTER TYPE cycling.fullname
RENAME middle to middlename
  AND last to lastname
  AND first TO firstname;

Displaying command results

DESC TYPE cycling.fullname;
CREATE TYPE cycling.fullname (
    first text,
    last text,
    middle text
);