3706 teradata 语句报错_teradata中的表刪除表

如果表存在，我嘗試使用C＃刪除Teradata數據庫中的表。teradata中的表刪除表

cmd.CommandText = string.Format("IF EXISTS

(SELECT * FROM sysobjects WHERE type = 'U' AND name = '{0}')

BEGIN DROP TABLE '{0}' END", Customer.TableName);

cmd.ExecuteNonQuery();

但上面總是失敗：

{"[Teradata Database] [3706] Syntax error: expected something between the beginning of the request and the 'IF' keyword."}

二碼我想，下面的代碼工作！

cmd.CommandText = "select count (*) from Customer.TableName";

reader = cmd.ExecuteReader();

if (reader.FieldCount > 0)

{

reader.Close();

cmd.CommandText = "Drop table Customer.TableName";

reader = cmd.ExecuteReader();

}

但是，它只有當表格存在時才起作用。如果表Customer.TableName不存在，那麼就會接受這種

"select count (*) from Customer.TableName";

reader = cmd.ExecuteReader();