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); }