May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – List All the Tables for All Databases Using System Tables

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure, SQL System Table, undocumented SQL
Today we will go over very simple script which will list all the tables for all the database. sp_msforeachdb 'select "?" AS db, * from [?].sys.tables' Update: Based on comments received below I have updated this article. Thank you to all the readers. This is good example where something small like this have good participation from…
Read More

SQL SERVER – DBCC commands List – documented and undocumented

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Server DBCC, undocumented SQL
Database Consistency Checker (DBCC) commands can gives valuable insight into what’s going on inside SQL Server system. DBCC commands have powerful documented functions and many undocumented capabilities. Current DBCC commands are most useful for performance and troubleshooting exercises. To learn about all the DBCC commands run following script in query…
Read More