一、c# 判断表是否存在
string sqlStr = "IF OBJECT_ID('dbzDBInfo','u') IS NULL SELECT 0 ELSE SELECT 1";
SqlCommand cmd = new SqlCommand(sqlStr, conn);
object obj= cmd.ExecuteScalar();
if (obj.ToString() == "1")
{
MessageBox.Show("已创建表");
}
else
{
MessageBox.Show("未创建表");
}
二、创建表前 先判断是否存在
string sqlStr= "IF OBJECT_ID('dbzDBInfo','u') IS NULL BEGIN CREATE TABLE dbzDBInfo (pcName varchar(50), xjfCardID varchar(50), xjfSwapID varchar(50)) SELECT 1 END ELSE SELECT 0";
SqlCommand command = new SqlCommand(sqlStr, conn)
object obj = command.ExecuteScalar();
if (obj.ToString() == "1")
{
MessageBox.Show("创建成功");
}
else
{
MessageBox.Show("创建失败");
}