column names of the table

Hi guys,

Is there any function that can the column names of the table I know about the sp_help but I want I'm going to call this from my .net application

Thanks




Answer this question

column names of the table

  • 0x00

    try this
    select column_name from information_schema.columns where table_name ='agents'



  • DamienAtCox

    Thank guys!!!

  • Roda Chan

    How about using the INFORMATION_SCHEMA.COLUMNS view -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ wrote in message news:2ff402f1-91fb-4795-aee4-bc05d3efcffa@discussions.microsoft.com... > Hi guys, > > Is there any function that can the column names of the table I know > about the sp_help but I want I'm going to call this from my .net > application > > > > Thanks > >
  • column names of the table