sciserver / graywulf

Database cluster federation toolkit
2 stars 3 forks source link

Suggestion: automatically create primary key in tables on nullable column. #61

Open mtaghiza opened 7 years ago

mtaghiza commented 7 years ago

When I manually tried to create the primary index on my own table, column ObjectID, it complained that the column is nullable. I see that the other (automatic) option is to recreate the table with an identity column instead. Could we better copy the same table now defined with a not null ObjID column and then make it the primary index? It would complain anyways if the ObjID column has repeated values.