Fetch the DB Object Backed by an External Database
SELECT OBJECT_SCHEMA_NAME(d.referencing_id) AS referencing_schema, OBJECT_NAME(d.referencing_id) AS referencing_object, o.type_desc AS referencing_type,
Apr 13, 20261 min read
Command Palette
Search for a command to run...
#sql-server
Articles tagged with #sql-server
sp_helptext for viewing definition in SQL Server
In SQL Server, the sp_helptext system stored procedure is a handy tool for the developers to retrieve the definition of SQL Server objects such as stored procedure, views, triggers and user-defined functions. This is much faster than navigating throu...
Apr 7, 20231 min read7Get size of all tables in database
SELECT o.name AS ObjectName, SUM(reserved_page_count) * 8.0 / 1024 AS SizeinMB FROM sys.dm_db_partition_stats AS ps INNER JOIN sys.sysobjects AS o ON ps.object_id = o.id GROUP BY o.name ORDER BY SizeinMB DESC;
Jan 12, 20231 min read4