Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2007
    Posts
    6

    Talking Unanswered: same filed with different table in sql server

    im using EmpName filed in lot of tables in sql server data base.

    how to write a query to find how many tables contains EmpName


    thanks in advance

    gowri

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    write a query against the information_schema.columns view

    by the way, i'm curious, why did you post a sql server question in the oracle forum?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    He got the answer once here, so his hopes were that he'll get it once again. And he did! Oracle forum rules

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •