Como saber quantidade de linhas, colunas e tamanho de cada tabela no banco de dados.
USE SeuBancoDeDados GO CREATE TABLE #temp ( nome_tabela SYSNAME, linhas INT, tamanho_reservado VARCHAR(50), tamanho_dados VARCHAR(50), tamanho_indice VARCHAR(50), tamanho_naoUsado VARCHAR(50) ) SET nocount ON INSERT #temp EXEC Sp_msforeachtable 'sp_spaceused ''?''' SELECT a.nome_tabela, a.linhas, Count(*) AS quantidade_colunas, a.tamanho_dados FROM #temp a INNER JOIN information_schema.columns b ON a.nome_tabela COLLATE database_default = b.table_name COLLATE database_default GROUP BY a.nome_tabela, a.linhas, a.tamanho_dados ORDER BY Cast(Replace(a.tamanho_dados, ' KB', '') AS INTEGER) DESC DROP TABLE #temp
Port video games have actually long been a popular type of entertainment, providing exhilarating gameplay…
When it pertains to online gambling, safety needs to be a top issue for every…
There are many reasons to play no-cost online casino games in the coming year. The…
On the internet casinos have acquired tremendous appeal in recent times, offering gamers with the…
Welcome to our useful post concerning the very best casino site game! Whether you're a…
The random number generator (or RNG) is the program that generates the outcome of every…