DB2 list schemas of a database

Posted by: DBA DB2, on 11 Jul 2011 | View original | Bookmarked: 0 time(s)

How to do a DB2 list schemas ?  Step 1 Connect to the database  db2 connect to my_database  Step 2 Execute this query  select schemaname from syscat.schemata  The recordset is something like :   Author: Jack Vamvas(http://www.dba-db2.com) ...

Advertisement
Free Agile Project Management Tool from Telerik
TeamPulse Community Edition helps your team effectively capture requirements, manage project plans, assign and track work, and most importantly, be continually connected with each other.
Category: XSD | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 413 | Hits: 10

Similar Posts

  • Migrating to Postgresql with my friend NHibernate more
  • Experimenting with MongoDB from C# more
  • Getting Loopy (Matt Gertz) more
  • Make SharePoint 2007 Act Like SharePoint 2010, Updated more
  • Bulletproof Database Synchronization with dbForge Schema Compare for SQL Server 1.50 more
  • PDC 2009 Sessions Posted more
  • Ruminations on Multi-Tenant Data Architectures more
  • SQL Server 2005/ SQL Server 2008 - Rebuild or Reorganize ALL Indexes in a Database more
  • Eloquera Database - the web-oriented client/server object database for .NET more
  • Unit Testing in EF v1 - the database conundrum more

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD