create the table automatically

• Mad-Dog

  SSCertifiable

  Points: 6117

  More actions

  August 4, 2008 at 11:43 pm

  #130439

  Hi,

  is there a way to create the table automatically (like select into)that will hold the info from the query?

  RESTORE HEADERONLY FROM DISK = N'C:\test.bak'

  if no is there a way to see the datatype and name for every column in the query?

  THX

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  August 5, 2008 at 12:00 am

  #853017

  is there a way to see the datatype and name for every column in the query?

  Yes, it is listed in the BOL.

• Mad-Dog

  SSCertifiable

  Points: 6117

  More actions

  August 5, 2008 at 12:59 am

  #853029

  Thx but this i know.

  i need to see it in the query results.

  is it doable?

  and what about my first question? is it doable too?

  THX