[geeklog-devel] MS SQL question

[Michael Jervis]

SELECT 1 FROM sysobjects WHERE name='{$_TABLES[$table]}' AND XTYPE='U'

is the full answer (tested) to the question.

On Wed, Jun 25, 2008 at 19:48, Michael Jervis <mjervis at gmail.com> wrote:

> SELECT 1 FROM sysobjects WHERE name= '{$_TABLES[$table]}'

>

> Probably want to check XTYPE as well, but I can't recall right now the

> correct value for table.

>

> On Wed, Jun 25, 2008 at 19:44, Dirk Haun <dirk at haun-online.de> wrote:

>> In the install script, we have this function:

>>

>> /**

>>  * Check if a table exists

>>  *

>>  * @param   string $table   Table name

>>  * @return  boolean         True if table exists, false if it does not

>>  *

>>  */

>> function INST_checkTableExists ($table)

>> {

>>    global $_TABLES, $_DB_dbms;

>>

>>    $exists = false;

>>

>>    if ($_DB_dbms == 'mysql') {

>>        $result = DB_query ("SHOW TABLES LIKE '{$_TABLES[$table]}'");

>>        if (DB_numRows ($result) > 0) {

>>            $exists = true;

>>        }

>>    }

>>

>>    return $exists;

>> }

>>

>> As can be seen, it's only covering MySQL. How would you check for the

>> existance of a table in MS SQL?

>>

>> bye, Dirk

>>

>>

>> --

>> http://www.geeklog.net/

>> http://geeklog.info/

>>

>> _______________________________________________

>> geeklog-devel mailing list

>> geeklog-devel at lists.geeklog.net

>> http://eight.pairlist.net/mailman/listinfo/geeklog-devel

>>

>

>

>

> --

> Michael Jervis

> mjervis at gmail.com

> 504B03041400000008008F846431E3543A820800000006000000060000007765

> 62676F642B4F4D4ACF4F0100504B010214001400000008008F846431E3543A82

> 0800000006000000060000000000000000002000000000000000776562676F64

> 504B05060000000001000100340000002C0000000000

>




-- 
Michael Jervis
mjervis at gmail.com
504B03041400000008008F846431E3543A820800000006000000060000007765
62676F642B4F4D4ACF4F0100504B010214001400000008008F846431E3543A82
0800000006000000060000000000000000002000000000000000776562676F64
504B05060000000001000100340000002C0000000000