hi, i trying to show out all my tables using mssql.
for mysql i can do this
$show = "SHOW TABLES";
$query = mysql_query($show);
but if it is mssql, is there a command for that?
select * from SYSOBJECTS where TYPE = 'U' order by NAME
ok, thanks. i got the solution, for mssql is select * from information_schema.tables