public bool J_IsDatabaseObjectExist(J_DatabaseObjectType DatabaseObjectType, string TableName, string ColumnName, string DataType, int ColumnSize)
{
try
{
if (DatabaseObjectType == J_DatabaseObjectType.Tables)
{
S_SQL = "SELECT COUNT(*) AS NO_OF_TABLES " +
"FROM INFORMATION_SCHEMA.COLUMNS " +
"WHERE UPPER(TABLE_NAME) = '" + TableName.ToUpper() + "' ";
if (ColumnName != "" && ColumnName != null)
S_SQL += "AND UPPER(COLUMN_NAME) = '" + ColumnName.ToUpper() + "' ";
if (DataType != "" && DataType != null)
S_SQL += "AND UPPER(DATA_TYPE) = '" + DataType.ToUpper() + "' ";
if (ColumnSize != 0)
S_SQL += "AND CHARACTER_MAXIMUM_LENGTH = " + ColumnSize + " ";
}
else if (DatabaseObjectType == J_DatabaseObjectType.Procedures)
{
S_SQL = "SELECT COUNT(*) AS NO_OF_PROCEDURES " +
"FROM SYS.ALL_OBJECTS " +
"WHERE TYPE = 'P' " +
"AND UPPER(NAME) = '" + TableName.ToUpper() + "' ";
}
if (Convert.ToInt64(Convert.ToString(this.gExecuteScalar(CommandType.Text, S_SQL))) > 0) return true;
return false;
}
catch
{
return false;
}
}
public bool J_IsDatabaseObjectExist(J_DatabaseObjectType DatabaseObjectType, string ProcedureName)
{
return J_IsDatabaseObjectExist(DatabaseObjectType, ProcedureName, null, null, 0);
}
