show all tables

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  May 26, 2004 at 3:19 pm

  #108435

  Hi ,

  Is there a command to show all tables in a database in sql server? Is it possible to see all the tables in all databases using a command? Suppose if i want all the dependencies (like which table is dependent on which) how can I do that?

  Thanks in advance,

  Sridhar!! 

• MikeMcDonald

  SSChasing Mays

  Points: 643

  More actions

  May 26, 2004 at 3:54 pm

  #507934

  1st question ... select * from INFORMATION_SCHEMA.TABLES

  Michael

• rockmoose

  SSCarpal Tunnel

  Points: 4601

  More actions

  May 27, 2004 at 2:08 am

  #507958

  2nd question ... 1 way:

  exec sp_MsForeachTable 'exec sp_MStablerefs @tablename = ''?'', @direction = ''both'''

  /rockmoose

  
  You must unlearn what You have learnt