How list out all tables in MSSQL?

Question

I'm using the code below to show the tables in my database.

I get "Connected to database" but nothing else. Is my code correct? can I use another way to get the info I need?

<?php 
$link = mssql_connect('HOST', 'user', 'pass');

if (!$link || !mssql_select_db('dbname', $link)) {
    die('Unable to connect or select database!');
}else{
echo"Connected to database";
}


$v = mssql_query("Select name from sysobjects where type like 'u'");
$row = mssql_fetch_array($v);

echo "<br>";  echo $row[0]; echo "<br>";


mssql_free_result($v);
?>

Solution 1

Alternate way, also fetches schema name

SELECT TABLE_CATALOG ,
        TABLE_SCHEMA ,
        TABLE_NAME ,
        TABLE_TYPE
FROM INFORMATION_SCHEMA.TABLES

Solution 2

SELECT * FROM sys.Tables;

Should do the magic :-D

And if u want to see all columns, i would do

SELECT TOP 1 * From Tablename;

so u'll get one row with all Columns, its not perfect but it does the trick if u just want to know sth

Comments

[ADM]

Thaks MadBender, but still no results, blank page. Do you think the problem may be database permissions or something like that? I'm not hosting the database and the people hosting it may have forgotten something. Thanks again

[MadBender]

Yes, it's possible. Try to connect and execute this query with some application like SSMS or SQL Explorer. It may give you more detailed error message.

[MadBender]

Or maybe there are no tables in that DB

[ADM]

Hmm I wish I could install any of this in the host, but I cannot, another way of doing it? Thanks once again

[ADM]

Probably you're right. I'll get to the hosting service. Thanks a ton!