Apps Demo | Technical Dost

Showing posts from January, 2021Show all

Drop all foreign key from all tables sql server

SQL Server

Drop all foreign key from all tables sql server

Apps Demo January 12, 2021

Drop all foreign key from all tables sql server DECLARE @SQL VARCHAR(MAX)='' SELECT @SQL = @SQL + 'ALTER TABLE ' + QUOTENAME(FK.TABL…

Get size of all tables in database

SQL Server

Get size of all tables in database

Apps Demo January 07, 2021

get-size-of-all-tables-in-database SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows, SUM(a.total_pages) * 8 AS TotalSpaceKB…