We're using GP 10, and I'm doing some database clean up and notice hundreds of tables and stored procedures that named in the format of dbo.zDP_xxx_n, where 'xxx' is a "regular" table name, and 'n' is a number, or iteration. For example, I see these tables:
dbo.zDP_RM00101F_1, dbo.zDP_RM00101F_2, dbo.zDP_RM00101F_3, dbo.zDP_RM00101F_4, dbo.zDP_RM00101F_5, dbo.zDP_RM00101F_6, dbo.zDP_RM00101F_7, dbo.zDP_RM00101F_8
What are these and where do they come from? Are they all needed? Can they be cleaned up somehow?
If you are seeing tables with names starting with zDP that sounds wrong. I would expect all the SQL objects staring with zDP to be stored procedures. The default company database installation will have over 20,000 stored procedures, this is normal. Here is a blog post explaining what these do in more detail: blogs.msdn.com/.../what-do-the-zdp-auto-generated-stored-procedures-do.aspx.
Thanks Victoria. I went back and looked and you are correct, these are only Stored Procedures, and not tables, and I have 24,442 of them. As long as this is normal, then okay.