Re: Empty Table?

From: "Tom Ellison" <tellison@xxxxxxxxxxx>
Date: Fri, 31 Mar 2006 09:55:40 -0600

Dear Marc:

How about:

SELECT COUNT(*)
FROM YourTable

Tom Ellison

"Marc Meltzer" <mrmeltzer@xxxxxxxxxx> wrote in message
news:ufLE$gNVGHA.2360@xxxxxxxxxxxxxxxxxxxxxxx

What query can I run to determine if a table is empty? I have a
placeholder table where whatever values it contains will be copied into
another table. I want to make sure that the table is not empty before
proceeding.

Thank you!
Marc

Follow-Ups:
- Re: Empty Table?
  - From: Marc Meltzer

References:
- Empty Table?
  - From: Marc Meltzer

Prev by Date: Re: Help with query
Next by Date: Re: Explicitly declare the variable
Previous by thread: Empty Table?
Next by thread: Re: Empty Table?
Index(es):
- Date
- Thread