Post reply

query a column

  • November 28, 2005 at 11:21 pm

    #166693

    how do i know/query a specific column from all the tables?

    pls note that the table is not present on all tables.

    tnx.

  • November 29, 2005 at 12:03 am

    #606323

    Hi

    Table Syscolumns store all columns and information about it . it store parm info of proc  .  if you are looking to query name from all table in a db .Select Name and id from syscolumns .ID is id of table/proc ect  . using Id query out Table name from sysobjects . create a query string  .

     

    Regards

    padmakumar

  • November 29, 2005 at 11:24 am

    #606501

    Just to clarify what padmakumar is saying..use a query like this...

    select sc.name as ColumnName, so.name as TableName 
from syscolumns sc
inner join sysobjects so on
sc.id = so.id
where sc.name = 'colName'
order by so.name







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 3 posts - 1 through 2 (of 2 total)

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