Post reply

object name needed

  • June 10, 2008 at 10:58 pm

    #121951

    can anyone tell me the system table name which stores all user table names with their attribute names. As sysobjects stores table name and detals, sysindexes stores table id, rowcnt etc. similiarty is there any table which stores attrinute name of a table.'

    dont aks me to use sp_help tablename , coz it wont allow search on attribute name basis

  • June 11, 2008 at 12:25 pm

    #827463

    Try:

    Use DBname

    select * from information_schema.columns

    Manu Jaidka

  • June 11, 2008 at 10:07 pm

    #827634

    thanks all,

    actually i found the answer,

    use simple querry

    select c.name, c.id, o.name from syscolumns c join sysobjects o on o.id =c.id where c.name='student_name'

  • June 11, 2008 at 10:09 pm

    #827635

    thaks manu

    ur querry worked very well

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

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