I have a table that includes data from all the counties in New York State. I want to delete most of that data so I only have 7 counties in the attribute table. I can run a selection query and delete the rows I don't want. But, when I open that shapefile again in another map, the data from all the counties is still in the table.
How do I permanently delete table data from a shapefile or efficiently export just the data I want to a new shapefile layer?