Delete a user-defined type (UDT) in Amazon Keyspaces - Amazon Keyspaces (for Apache Cassandra)
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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

To delete a UDT in a keyspace, you can use the DROP TYPE statement in CQL, the delete-type command with the Amazon CLI, or the console.

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

  1. Sign in to the Amazon Web Services Management Console, and open the Amazon Keyspaces console at https://console.amazonaws.cn/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.

Cassandra Query Language (CQL)
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.

CLI
Delete a user-defined type (UDT) with the Amazon 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"
}