Home Forums SQL Server 2005 T-SQL (SS2K5) Retrieve column headers for INFORMATION_SCHEMA RE: Retrieve column headers for INFORMATION_SCHEMA

  • February 11, 2009 at 7:34 am

    #942131

    {edit}ok, what are "column ?Headers...that's what i'm not understanding.

    maybe I'm oversimplifying, but since the table_name exists in information_schema.columns, why not just select directly fromt here?

    select * from

    INFORMATION_SCHEMA.COLUMNS

    where table_name ='mytable'

    what did i miss on your question?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!