[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