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?