Script views in SQL 2000

• ramadesai108

  SSChampion

  Points: 10609

  More actions

  December 7, 2010 at 12:14 pm

  #99440

  Hi,

  How do I Script views in SQL 2000 with columns. I don't need a create script, but I need to script all the columns in a view. If I run the query "select * from INFORMATION_SCHEMA.COLUMNS", it gives me a list of all the table names along with the columns in a database. I need exactly same for views.

  Thnx.

• bhaaratbchopra

  SSC Enthusiast

  Points: 151

  More actions

  December 9, 2010 at 12:40 am

  #1260444

  Same query will work for view.

  select * from information_schema.columns where table_name='View Name'

  reply Me if I am not getting your question.