I want to do this to get the unique id across schema, for offline access so the function will get it.
Is there any way i can do this other than having a trigger and a counter table ??
You can do this in sql server like this.
Thanks
Sonali