note 92722 added to book.mssql

Hi, i was need some short and simple script to list all tables and columns of MSSQL database. There was nothing easy to explain on the net, so i've decided to share my short script, i hope it will help. $all = MSSQL_Query("select TABLE_NAME, COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS order by TABLE_NAME, ORDINAL_POSITION"); $tables = array(); $columns = array(); while($fet_tbl = MSSQL_Fetch_Assoc($all)) { // PUSH ALL TABLES AND COLUMNS INTO THE ARRAY $tables[] = $fet_tbl[TABLE_NAME]; $columns[] = $fet_tbl[COLUMN_NAME]; } $sltml = array_count_values($tables); // HOW MANY COLUMNS ARE IN THE TABLE foreach($sltml as $table_name => $id) { echo "<h2>". $table_name ." (". $id .")</h2><ol>"; for($i = 0; $i <= $id-1; $i++) { echo "<li>". $columns[$i] ."</li>"; } echo"</ol>"; } ---- Server IP: 217.73.17.12 Probable Submitter: 89.173.47.113 ---- Manual Page -- http://www.php.net/manual/en/book.mssql.php Edit -- https://master.php.net/note/edit/92722 Del: integrated -- https://master.php.net/note/delete/92722/integrated Del: useless -- https://master.php.net/note/delete/92722/useless Del: bad code -- https://master.php.net/note/delete/92722/bad+code Del: spam -- https://master.php.net/note/delete/92722/spam Del: non-english -- https://master.php.net/note/delete/92722/non-english Del: in docs -- https://master.php.net/note/delete/92722/in+docs Del: other reasons-- https://master.php.net/note/delete/92722 Reject -- https://master.php.net/note/reject/92722 Search -- https://master.php.net/manage/user-notes.php