sql 2005判断某个表或某个表中的列是否存在
/// <summary>
/// 判断是否存在某表的某个字段
/// </summary>
/// <param name="tableName">表名称</param>
/// <param name="columnName">列名称</param>
/// <returns>是否存在</returns>
public static bool ColumnExists(string tableName, string columnName)
{
string sql = "select count(1) from syscolumns where [id]=object_id('" + tableName + "') and [name]='" + columnName + "'";
object res = GetSingle(sql);
if (res == null)
{
return false;
}
return Convert.ToInt32(res) > 0;
}
/// <summary>
/// 表是否存在
/// </summary>
/// <param name="TableName"></param>
/// <returns></returns>
public static bool TabExists(string TableName)
{
string strsql = "select count(*) from sysobjects where id = object_id(N'[" + TableName + "]') and OBJECTPROPERTY(id, N'IsUserTable') = 1";
//string strsql = "SELECT count(*) FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[" + TableName + "]') AND type in (N'U')";
object obj = GetSingle(strsql);
int cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
if (cmdresult == 0)
{
return false;
}
else
{
return true;
}
}
更多相关文章
- Mssql根据表名获取字段
- Mysql查询时,对于数值型字段加单引号会引起的误解~
- 如何在Android应用里对HTTP请求头部添加适当的User-Agent字段
- 如何在android 5.0(L)中运行应用程序活动名称?
- 使用Java解析XML文件以获取名称列表
- Javassist生成class(生成类,方法,字段,注解)
- dom4j-java-如何获取root中具有特定元素名称的所有元素(父元素或
- Play 2.0生成隐藏字段而不使用div包装器
- JAVAWEB网站开发,一对多,多对一,主表与子表(主外键)相连接,会导致主表