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

"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

  • Re: Performance really poor if calling data from sql clients
    ... I can't vouch for any of the VS components when it comes to performance ... since I don't use them for database access. ... profiler to see what is happening on the sql server end. ... Network pack size = 4096 ...
    (microsoft.public.sqlserver.clients)
  • Re: Need Feedback : problem since applying SP2
    ... aspnet_wp.exe recycles itself if there is a lock or memory leak ... > database access after applying .net framework SP2. ... > The error message indicates a security problem for the web ... > server to connect to the SQL server (it says Sql server is ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Need Feedback : problem since applying SP2
    ... database access after applying .net framework SP2. ... I had a couple of web services which exposed SQL server ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Import data from multiple acces db
    ... How can I change the filename for an Access Connection? ... The really problem is that the database access is ... > My idea is to insert database location on an sql server table and use this ... > I try to made a dts but i cannot succeed in. ...
    (microsoft.public.sqlserver.dts)
  • Import data from multiple acces db
    ... I need to import data from database access to sql server database, ... I try to made a dts but i cannot succeed in. ... I have an sql server 2000 sp3a ...
    (microsoft.public.sqlserver.dts)