July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Query to Find ByteSize of All the Tables in Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure
SELECT CASE WHEN (GROUPING(sob.name)=1) THEN 'All_Tables'    ELSE ISNULL(sob.name, 'unknown') END AS Table_name,    SUM(sys.length) AS Byte_Length FROM sysobjects sob, syscolumns sys WHERE sob.xtype='u' AND sys.id=sob.id GROUP BY sob.name WITH CUBE Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More

SQL SERVER – Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL Stored Procedure
UPDATE : SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database This is very long query. Optionally, we can limit the query to return results for one or more than one table. SELECT K_Table = FK.TABLE_NAME, FK_Column = CU.COLUMN_NAME, PK_Table = PK.TABLE_NAME, PK_Column = PT.COLUMN_NAME, Constraint_Name…
Read More