Programming Help

Web Development

Welcome to Dream.In.Code
	Getting Help is Easy! Join 118,921 Programmers for FREE! Ask your question and get quick answers from experts. There are 1,994 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now! Chat LIVE With a Expert Register to Make This Box Go Away!

evance	9 May, 2008 - 10:28 PM Post #1
New D.I.C Head Joined: 9 May, 2008 Posts: 2	Dear sirs, In our company we have a table called the customer_master where all the customer names are stored.Now the prob is , we have to find which customer code has never been used till date..We have around 700 tables and customer_code is used in most of the tables.So im not able to find the unused cutomer_code and delete it.Please help me out with the above problem so that I can tell the system to bring the unused customer_code. ... Thanks and Regards G.EVANCE HEALLY DEVELOPER NewAge Software & Solutions (I) Pvt Ltd 14/8, 21st Avenue, Ashok Nagar, Chennai 600 083 Mobile : +91 99949 63429; off-Tel: +91 44 42038368 e-mail : evance_h@newage-global.com
	This Post Was Helpful! ^New!

mikeblas	14 May, 2008 - 09:21 PM Post #2
D.I.C Head Joined: 8 Feb, 2008 Posts: 155 Thanked 1 times My Contributions	It's remarkable that you have 700 tables, but no solution for referential integrity. If you really need to sort through those tables, then you need to sort through those tables -- there's no shortcut solution.
	This Post Was Helpful! ^New!