Get Microsoft Sql table list form PHP
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.