vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| can someone explain why (other than: You Can't Do That) it is that the ALTER TABLE ...RESTART WITH 999 is not allowed on 390/v6?? looking at the SYSIBM tables SYSSEQUENCES and SYSSEQUENCESDEP structures (i don't have grant to see the ...DEP table for some reason), it's clear that the IDENTITY columns are supported by these tables. it is frustrating to tell my developer colleagues that we have to nuke tables just to restart the ID columns. thanks, robert |