A Very Nice Article on the structure and contents of SharePoint Content Database.
Quote
Talking about Inspecting The SharePoint Content Database – Ethan’s blog
Inspecting The SharePoint Content Database
Day: January 19, 2009
Talking about SQL SERVER – 2005 – List all the database « Journey to SQL Authority with Pinal Dave
—-SQL SERVER 2005 System Procedures
EXEC sp_databases
EXEC sp_helpdb
—-SQL 2000 Method still works in SQL Server 2005
SELECT name
FROM sys.databases
SELECT name
FROM sys.sysdatabases
—-SQL SERVER Un-Documented Procedure
EXEC sp_msForEachDB ‘PRINT ”?”’
EXEC sp_databases
EXEC sp_helpdb
—-SQL 2000 Method still works in SQL Server 2005
SELECT name
FROM sys.databases
SELECT name
FROM sys.sysdatabases
—-SQL SERVER Un-Documented Procedure
EXEC sp_msForEachDB ‘PRINT ”?”’
Jerry Yasir's Blog 