Loading ...
Sorry, an error occurred while loading the content.

RE: [SQLQueriesNoCode] How to get Field name of a Table through query

Expand Messages
  • Doug Nelson
    A better way to do this is the use the information_schema views. http://www.devx.com/getHelpOn/10MinuteSolution/20561 This is becoming the preferred way to get
    Message 1 of 3 , Mar 24, 2005
    • 0 Attachment

      A better way to do this is the use the information_schema views.

       

      http://www.devx.com/getHelpOn/10MinuteSolution/20561

       

      This is becoming the preferred way to get information about the database structure.

       

      Doug Nelson

      SynApp north

      www.synappnorth.com


      From: nilesh babar [mailto:nilesh_babar2003@...]
      Sent: Thursday, March 24, 2005 7:23 AM
      To: SQLQueriesNoCode@yahoogroups.com
      Subject: Re: [SQLQueriesNoCode] How to get Field name of a Table through query

       

      Hi,

       

      use following query

       

      select name from syscolumns where id in (select id from sysobjects where name='employee')

       

      'employee'  is the table name.

       

      Cheers,

      Nilesh.

      govisathish <govisathish@...> wrote:



      Hi

      I need to get the field names of a Table through Query, I'm using SQL
      SERVER database . Can Any one help me in this regard

      sathish






      Send instant messages to your online friends http://uk.messenger.yahoo.com

    Your message has been successfully submitted and would be delivered to recipients shortly.