Search results

Hi, You are right that I should, but I don't because there are 1.6 million records of raw data. I know that all columns have duplicates, so that I can't use a single column. figuring out which combination of columns would produce a unique set of data that allows me to establish a PK is...

Hi, Unfortunately that wont do it because there are two tables with similar data and we need to run the process twice in order to find the primary key on each. That will allow us to relate the tables via the keys. Thanks

Hi Everyone, I have a challenging problem (at least for me it is) I have a table with about 200 columns, which are not logically named. there are 1.6 million records in the table. No column alone can form a PK as all of them have duplicate data. I do not know how many columns I need to...