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

CREATE TYPE IF NOT EXISTS cycling.fullname (
  firstname text,
  lastname text
ALTER TYPE cycling.fullname
ADD middlename text;
ALTER TYPE cycling.fullname
RENAME middlename TO middle
  AND lastname TO last
  AND firstname TO first;
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 (
    firstname text,
    lastname text,
    middlename text

Drop user-defined type

DROP TYPE IF EXISTS cycling.fullname;

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com