Home >Backend Development >PHP Tutorial >SQL statement to obtain all table information_PHP tutorial
SQL statement to obtain all table information_PHP tutorial
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-07-13 17:02:06928browse
exec sp_MSForEachTable
@precommand=N'
create table ##(
id int identity,
table name sysname,
number of fields int,
number of records int,
reserved Space Nvarchar(10),
used space varchar(10),
index used space varchar(10),
unused space varchar(10))',
@command1=N'insert # #(Table name, number of records, reserved space, used space, index used space, unused space) exec sp_spaceused ''?''
update ## set number of fields=(select count(*) from syscolumns where id= object_id(''?'')) where id=scope_identity()',
@postcommand=N'select * from ## order by id drop table ##'
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Block SQL Server injection vulnerability in three simple steps_PHP tutorialNext article：Block SQL Server injection vulnerability in three simple steps_PHP tutorial