Subject | System Domain Cleanup |
---|---|
Author | Alan McDonald |
Post date | 2005-05-19T09:42:55Z |
Let's say you create a table with raw datatypes - the server creates RDB$nnn
type domains for your fields.
Or you create a number of procedures each requiring numerous parameters -
the server creates RDB$nnn type domains.
Then you go back and change the raw datatypes to domains or you revisit your
procedures and drop quite a few while you prepare to re-write them.
I just wonder if any of all these system generated domains ever deleted. Do
they ever get dropped on backup/restore or some other process which
recognises that they are no longer needed/referenced.
Is the only way to get rid of these domains to extract metaddata, construct
new database, and pump data across?
Thanks
Alan
type domains for your fields.
Or you create a number of procedures each requiring numerous parameters -
the server creates RDB$nnn type domains.
Then you go back and change the raw datatypes to domains or you revisit your
procedures and drop quite a few while you prepare to re-write them.
I just wonder if any of all these system generated domains ever deleted. Do
they ever get dropped on backup/restore or some other process which
recognises that they are no longer needed/referenced.
Is the only way to get rid of these domains to extract metaddata, construct
new database, and pump data across?
Thanks
Alan