Dear Helpers,

        I want to check one column name is present in how many table in a
databse , and name of those tables. does mysql supports this function ?

Ex :
            Tables

          1>   Item master

                        columns  are ItemID, ItemName

          2> Item details

                        columns are  ItemID,Dateof purchase etc

         3>Item Dispatch

                        columns are ItemID, Date of Dispatch.

You can see the coulmn ItemID  present in three tables  , i want query so
that i can know itemid preset in these tables ,pls help me

Thanks  & regards,

shashi
----- DISCLAIMER -----

This message, along with any attachments, is proprietary to Velankani Information 
Systems and is intended solely for the use of the individual to whom it is addressed. 

It may contain privileged or confidential information and should not be circulated or 
used for any purpose other than for what it is intended.  If you have received this 
message in error, please notify the originator immediately.  If you are not the 
intended recipient, you are notified that you are strictly prohibited from using, 
copying, altering, or disclosing the contents of this message.  

Velankani Information Systems accepts no responsibility for loss or damage arising 
from the use of the information transmitted by this email including damage from virus.



--------------------------------------------------------------
Velankani Information Systems Ltd, Bangalore, India



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to