Spalte in DynamoDB Tabelle löschen

Question

Hello,

is it possible in an existing table in DynamoDB to delete a "column" that is no longer needed? e.g. there is a table "Products" and in this there are columns like id, EAN, gender etc.. Now the column "gender" is no longer needed and should be deleted. In the docs I couldn't find anything about this and the SQL command doesn't seem to work.

Thanks for the support in advance.

Brettski-AWS · Accepted Answer

The reason you're seeing a "column" listed in the console is because there is an item in the database with that attribute. In a NoSQL database you don't create columns as you would in a relational database; instead the structure of each item can be completely different and the console shows columns where attributes exist.

To "delete" the "column", find the item(s) that have the "gender" attribute and delete that attribute from the item.

Spalte in DynamoDB Tabelle löschen

Add your answer

Relevant content