Search:

Type: Posts; User: westerdaled

Search: Search took 0.01 seconds.

  1. Re: Setting RECNUM as the default primary key or unique index

    Thanks for the replies

    Martin, I think I hit an issue when I tried to add a new Primary Key to a RECNUM Table, after removing the previous composite primary keys . I seem to have caused Studio...
  2. Re: Setting RECNUM as the default primary key or unique index

    Hi @Garret

    Thanks for the reply. I am in DF Explorer v19.15.159 , I click, double click and right click on the Rec_ID column but no dialog pops up :confused: - SSMS it is not! I think we could...
  3. Re: Setting RECNUM as the default primary key or unique index

    Hi

    Did a quick experiment to see if I can't set Rec_ID as the primary key on new Table in DF. I think this illustrates the issue whereby we not able choose our desired primary key, regardless of...
  4. Re: Setting RECNUM as the default primary key or unique index

    Thanks very much Samuel, I will find out from the client whether the is any move to use the embedded ( retro:() DF tables. In the meantime, we can look to phase out those RECUM columns and replace...
  5. Setting RECNUM as the default primary key or unique index

    Hi

    Is there a way to create or modify a SQL Server table so that RECNUM can be set as either the primary key or unique key? When creating SQL Server tables in Studio, I check the RECUM Table...
Results 1 to 5 of 5