Table checking

Results 1 to 2 of 2

Thread: Table checking

  1. #1
    Jermaine Guest

    Default Table checking

    What function in ASP that you can use to check if a same table name exist in a certain database?

  2. #2
    Join Date
    Dec 1969

    Default RE: Table checking

    For SQL Server Use:<BR>--------------------<BR><BR>Select Count(*) From SysObjects where name=&#039;MyTable&#039;<BR><BR>For Oracle<BR>-----------<BR><BR>Select Count(*) From Tab Where Name=&#039;MyTable&#039;<BR><BR>If the above query returns a row then that table is present.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts