Retrieve the tables from an schema.

• sidhu.sardar

  SSC Journeyman

  Points: 83

  More actions

  February 10, 2009 at 10:02 pm

  #197022

  i have database which contains more than 500 tables and tables are categorized on the basis of schema. i want to retrieve the tables by schema name and find the relationship between them.

  please could suggest how to do this.

• Sriram-288748

  SSCrazy

  Points: 2874

  More actions

  February 10, 2009 at 10:10 pm

  #941796

  have join between sys.schemas and sys.objects

  Sriram