Hi Folks
I want to generate a surrogatekey directly in a table i mean neither using a flatfile nor using a database sequence.How is it possible and which properties i have to fill with what? say my colnume for surrogatekey is ID_NUMBER Number(25,0) PK and table name is TABLENAME.
The efforts will be appreciated.
Suurogate key generation in a database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Mon Jul 12, 2010 2:05 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: