Alex (SirShurf) Frenkel's Blog

A web log of a PHP professional

Posts Tagged ‘php

Get Microsoft Sql table list form PHP

leave a comment »

One of the things I lost time today was how to get the list of table from Ms SQL server from PHP on Unix (Ubuntu).

I will write another post how to connect to it later, but currently what I have found is that MsSQL does not have “SHOW TABLES” command like MySQL do.

In order to get the list of table we need to send:
select name from sysobjects where xtype = ‘U’

This way we would get all of the user tables in our database.

Written by Alex (Shurf) Frenkel

May 12, 2010 at 2:20 pm

Posted in Uncategorized

Tagged with , , , , ,

First Post

with one comment

Well, after reading many posts, I have desided to start my own blog to.

I have many reason for that, but the most importent for me currently is that I am tiered of searching for the same information again and again.

In this blog I would group all of the information I have found that I belive is needed for me to continue development of application.

Written by Alex (Shurf) Frenkel

April 17, 2010 at 2:27 pm

Posted in Uncategorized

Tagged with , , ,