show tables

[beginnerz]

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?

[sacx13]

select * from SYSOBJECTS where TYPE = 'U' order by NAME

or

sp_help



Best Regards
Adrian

[beginnerz]

ok, thanks. i got the solution, for mssql is select * from information_schema.tables