Showing posts from January, 2021Show all
SQL Server
Drop all foreign key from all tables sql server
Drop all foreign key from all tables sql server DECLARE @SQL VARCHAR(MAX)='' SELECT @SQL = @SQL + 'ALTER TABLE ' + QUOTENAME(FK.TABL…
Read more
SQL Server
Get size of all tables in database
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…
Read more
Social Plugin