SQL Server System Views: The Basics

Posted by: Simple Talk, on 27 Jan 2016 | View original | Bookmarked: 0 time(s)

When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the database, its tables, columns keys and indexes. SQL Server's plethora of system catalog views, INFORMATION_SCHEMA views, and dynamic management views contain all the metadata you need, but it isn't always obvious which views are best to use for which sort of information. Many of us could do with a simple explanation, and who better to provide one than Rob Sheldon?...

Category: Refactor | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 257 | Hits: 4

Similar Posts

  • SQLAuthority News SQL Server 2008 R2 System Views Map more
  • Connecting to SQL Azure with Telerik OpenAccess more
  • Migrating to Postgresql with my friend NHibernate more
  • Adding users to a TFS project when youre not on the domain more
  • Web Deployment Tool has gone RTW more
  • An alternative to Crystal more
  • PDC 2009 Sessions Posted more
  • Open SQL Port for specific IP by ASP.NET Website more
  • Understanding Reverse Proxy Servers and the Mailman more
  • PHP versus ASP.NET Windows versus Linux Whos the fastest ? 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