MaximumASP
Social Bookmarking
Online Shopping
asp.net hosting
UK online local dating
| More
Recent News » XSD

Indexes in DB2

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

 How to create a recordset of indexes in DB2 for a table?  ---To list all indexes for a schema and table db2 "Select indschema,indname,uniquerule,colnames from syscat.indexes where tabschema = '<MY_SCHEMA>' and tabname='<MY_TABLE>' order by indname" 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: 324 | Hits: 2

Similar Posts

  • DBA Become a better DB2 DBA more
  • DB2 DB2_RR_TO_RS environment variable more
  • SQL SERVER A Quick Note on DB_ID() and DB_NAME() Get Current Database ID Get Current Database Name more
  • SQL SERVER DBA or DBD? Database Administrator or Database Developer more
  • Migrating to Postgresql with my friend NHibernate more
  • Experimenting with MongoDB from C# more
  • "ADO.NET Entity data model" or "edmx" or "L2E" debug visualizer more
  • A Code of Conduct for DBAs more
  • Python for the SQL Server DBA more
  • SQL Backup 6: Wind of Change 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