Re: how to know the table is exist in the database


Thanks to all for your input.
"Mark Rae" <mark@xxxxxxxxxxxxxxxxxxxxxxxxxx> дÈëÏûÏ¢
news:uWemvlT2FHA.3420@xxxxxxxxxxxxxxxxxxxxxxx
> "joy.net" <luxingyu1@xxxxxxxxxxx> wrote in message
> news:%23DX0hgT2FHA.3912@xxxxxxxxxxxxxxxxxxxxxxx
>
> Depends on the database and/or on the database access method...
>
> E.g. if you want to know if the Orders table exists in SQL Server, send it
> the following scalar query:
>
> SELECT COUNT(*) FROM sysobjects WHERE name = 'Orders'
>
> If the result is 1, the table exists - if the result is 0, the table
doesn't
> exist.
>
>



.

Relevant Pages

  • Different level of users
    ... Can I set different level of users for a Database Access. ... of user-administrator can have a full access ... Is it possible doing so or there is any way to overcome this problem??? ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • Users Access?
    ... I have created one user named dbUser and gave different database access to ... to that user through query analyzer, ... Prev by Date: ...
    (microsoft.public.sqlserver.clients)
  • Re: Database design issue
    ... database access (be cause, your forex rates are stored in that database ... Can you throw some inputs in this regard. ... Prev by Date: ...
    (comp.lang.java.databases)
  • Re: how to know the table is exist in the database
    ... Depends on the database and/or on the database access method... ... E.g. if you want to know if the Orders table exists in SQL Server, ... SELECT COUNTFROM sysobjects WHERE name = 'Orders' ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: how to know the table is exist in the database
    ... executing sp_tables stored procedure is better since sysobjects ... Miha Markic [MVP C#] ... Blog: http://cs.rthand.com/blogs/blog_with_righthand/ ... > Depends on the database and/or on the database access method... ...
    (microsoft.public.dotnet.framework.adonet)