Got curious so looked at the API documentation.
@cilzzz, you probably need to use https://www.elastic.co/guide/en/elasticsearch/reference/6.1/docs-delete-by-query.html
Something like
POST twitter/_delete_by_query
{
"query": {
"match": {
"type": "mssql"
}
}
}
Not exactly what you wanted to do. It should remove all documents of type: mssql but the mapping will remain. To remove a mapping you would have to reindex.