How to check the connection to the database without the name of its tables

Question

The point here is that I don’t have database table names , so please do not suggest choosing one table for this. SELECT COUNT (*) '

+3

Erez May 15, '11 at 13:08

3 answers

, , - DbConnection.GetSchema, , , ... , "heartbeat", .

+1

Jon Skeet 15 '11 13:12

You can run a command that does not query the table, for example:

select @@VERSION

+1

Chris fulstow May 15, '11 at 13:15

SirViver · Accepted Answer · 2011-05-15T13:13:44+0000

It depends on the database, but usually there are some tables that always exist or a table is not even required.

For Oracle:

SELECT 1 FROM dual

For SqlServer:

SELECT 1

Not very elegant, but usually does the job if you know the brand of the database.