SQL Prompt 6 replication objects in suggestions
SQLUser4711
Posts: 8
Hello,
is it possible to remove the replication objects from the suggestions or change the order of the suggestions?
Why do want this?
For every table (e.g. dbo.Personnel) in the replication exists a conflict table (conflict_dbo_Personnel). The conflict tables are shown before the original table. In a worst case scenario I have so scroll down more than 50-100 rows to find the table I was looking for. I'm using SQL Prompt version 6.5.0.336. In a previous version of SQL Prompt (6.3?) the conflict tables were not shown at the top.
is it possible to remove the replication objects from the suggestions or change the order of the suggestions?
Why do want this?
For every table (e.g. dbo.Personnel) in the replication exists a conflict table (conflict_dbo_Personnel). The conflict tables are shown before the original table. In a worst case scenario I have so scroll down more than 50-100 rows to find the table I was looking for. I'm using SQL Prompt version 6.5.0.336. In a previous version of SQL Prompt (6.3?) the conflict tables were not shown at the top.
Comments
We've been thinking about moving change tracking tables to the bottom of the suggestions for a similar reason, so I think conflict tables would also be an excellent addition if we implement that. We use UserVoice to help track feature requests so I've opened a new one here - please do add your vote as it helps us when prioritising what to work on next.
I don't think we've changed the ordering of tables recently, they're still alphabetically ordered so maybe the tables you were using previously came before "conflict"?
Thanks,
Aaron.
I'm using the table alias as search argument. If I'm looking for the table PersonnelContactInformation, I'm only typing PCI. If the complete name PersonnelContactInfo... is used, the table is shown before the conflict table.
I voted for the feature requests.
Roland