Delete a user-defined type (UDT) in Amazon Keyspaces

Delete a user-defined type (UDT) with the Amazon Keyspaces console

1. Sign in to the AWS Management Console, and open the Amazon Keyspaces console at https://console.aws.amazon.com/keyspaces/home.

2. In the navigation pane, choose Keyspaces, and then choose a keyspace from the list.

3. Choose the UDTs tab.

4. Choose the UDT that you want to delete. On the Used in you can confirm that the type you want to delete isn't currently used by a table or other UDT.

5. Choose Delete above the Summary.

6. Type Delete in the dialog that appears, and choose Delete UDT.

Delete a user-defined type (UDT) with CQL

• To delete a type, you can use the following statement.

  DROP TYPE my_keyspace.my_udt;

  For more information about CQL syntax, see DROP TYPE.

Delete a user-defined type (UDT) with the AWS CLI

1. To delete a type, you can use the following command.

   aws keyspaces delete-type
   --keyspace-name 'my_keyspace'
   --type-name 'my_udt'

2. The output of the command looks similar to this example.

   {
       "keyspaceArn": "arn:aws:cassandra:us-east-1:111122223333:/keyspace/my_keyspace/",
       "typeName": "my_udt"
   }