Obtain the list of views, tables, functions, triggers of a databases

• Teresita Castro

  SSCommitted

  Points: 1568

  More actions

  July 14, 2008 at 11:05 am

  #209841

  Hi

  I need to make a list of the views, tables, functions, triggers of a databases

  How can I do that?

  Thanks

• Grant Fritchey

  SSC Guru

  Points: 399278

  More actions

  July 14, 2008 at 11:20 am

  #842568

  Access the INFORMATION_SCHEMA views. There's one for tables, columns, routines, parameters...

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning