Post reply

Regarding column value

  • March 27, 2008 at 3:38 am

    #188546

    Hi all,

    i need a query to get what are the tables that have the value 'cat'.

  • March 27, 2008 at 1:25 pm

    #794826

    Are you trying to search for 'cat' in a particular column or every column of every table? What exactly is the purpose for this search?


    My blog: http://jahaines.blogspot.com

  • March 27, 2008 at 7:16 pm

    #794963

    Can you please clarify that you need 'cat' as value in column or substring in column name?

  • March 28, 2008 at 12:15 am

    #795000

    Hai all,

    Suppose i am having 10 tables in a database.in that 10 tables,5 tables are having the column value as 'cat'.i need 5 tables name alone.more over it must be a single query.please don't go for cursor & while loop.

  • March 28, 2008 at 4:08 am

    #795047

    Hi,

    I quess you should use the UNION for this.

    SELECT Column1, Column2 FROM Table1 WHERE Column1='cat' OR Column2='cat'

    UNION ALL

    SELECT Column1, Column2 FROM Table2 WHERE Column1='cat' OR Column2='cat'

    UNION ALL

    SELECT Column1, Column2 FROM Table3 WHERE Column1='cat' OR Column2='cat'

    UNION ALL

    ......

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • March 28, 2008 at 6:16 am

    #795107

    vmsbalaji (3/28/2008)

    Hai all,

    Suppose i am having 10 tables in a database.in that 10 tables,5 tables are having the column value as 'cat'.i need 5 tables name alone.more over it must be a single query.please don't go for cursor & while loop.

    This will do it...

    SELECT Table_Catalog AS DBName,

    Table_Schema AS Owner,

    Table_Name AS TableName

    FROM Information_Schema.Columns

    WHERE Column_Name = 'Cat'

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • March 28, 2008 at 1:36 pm

    #795453

    vmsbalaji (3/28/2008)

    Hai all,

    Suppose i am having 10 tables in a database.in that 10 tables,5 tables are having the column value as 'cat'.i need 5 tables name alone.more over it must be a single query.please don't go for cursor & while loop.

    Value of the data in the column, or column name cat? Can you give an example of how you would do it with 1 table? You are being very unclear. Is the column name the same in all cases?

    Or are we talking about looking for the value of 'cat' in every row of every column of every table in every database?

    Please try to re-word again.

    Thank you

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply