I used the Secure Store to create connection in SharePoint 2010 Designer External Content Types Data Source Explorer. Later I changed some column names in the table.
I deleted the connection from Data Source Explorer and recreated it. I right clicked on the table and selected Create All Operations. When I clicked the Finish button, I got "The system definition with the same name as this data source already exists in the
Business Data Connectivity Metadata Store and it refers to a different data source. Cannot complete operation generation. Add a connection to this data source with a different name and try again."
I re-created the Secure Store using a different name in SharePoint 2010 Central Administration. I didn't find the option to choose the connection name in SharePoint 2010
Designer. After I clicked Add Connection, I entered the Database Server and the Database Name, selected Connect with Impersonated Window Identity, entered Secure Store name, and clicked OK. The connection created with the database name as before.