alexmcse
یک شنبه 11 بهمن 1394, 21:48 عصر
مثلا دیتابیس sample
آیا جدول A در دیتابیس فوق وجود دارد یا خیر?
چک کردن
:تشویق:
zidanerfan
یک شنبه 11 بهمن 1394, 22:29 عصر
لینک منبع (http://stackoverflow.com/questions/464474/check-if-a-sql-table-exists)
bool exists;
try
{
// ANSI SQL way. Works in PostgreSQL, MSSQL, MySQL.
var cmd = new OdbcCommand(
"select case when exists((select * from information_schema.tables where table_name = '" + tableName + "')) then 1 else 0 end");
exists = (int)cmd.ExecuteScalar() == 1;
}
catch
{
try
{
// Other RDBMS. Graceful degradation
exists = true;
var cmdOthers = new OdbcCommand("select 1 from " + tableName + " where 1 = 0");
cmdOthers.ExecuteNonQuery();
}
catch
{
exists = false;
}
}
vBulletin® v4.2.5, Copyright ©2000-1403, Jelsoft Enterprises Ltd.