On Mon, Dec 19, 2005 at 08:35:14AM -0800, vishal saberwal wrote: > So, is there no way i can version the stored procedures or tables. > Has anyone done anything similar. > Does any system table have a description or any field i could store the > version for the tables/stored procedures/views. No, there's not. And I don't think there's enough demand to warrant putting support for something like this in the backend. > thanks jim, but i think, If its just 20% tables changing and that two in a > sub-schema storing person details for example, i might not want to have > downtime on other applications that are not using person sub-system. Well, then setup a table so that you can store version info for specific components/schemas/what-have-you. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461