discontinuedPackage connect_database has been discontinued.

procedureExists method

Future<Result<bool>> procedureExists(
  1. String procName
)

Checks if a procedure or function exists.

Implementation

Future<Result<bool>> procedureExists(String procName) async {
  final p = _sanitize(procName);
  String query;

  switch (driver.type) {
    case DatabaseType.sybaseAnywhere:
      query = "SELECT 1 FROM SYS.SYSPROCEDURE WHERE proc_name = '$p'";
      break;
    case DatabaseType.sqlServer:
    case DatabaseType.postgresql:
      query = "SELECT 1 FROM information_schema.routines WHERE routine_name = '$p'";
      break;
  }
  return _checkExists(query);
}