discontinuedPackage connect_database has been discontinued.

viewExists method

Future<Result<bool>> viewExists(
  1. String viewName
)

Checks if a view exists.

Implementation

Future<Result<bool>> viewExists(String viewName) async {
  final sanitizedName = _sanitize(viewName);
  String query;

  switch (driver.type) {
    case DatabaseType.sybaseAnywhere:
      query = "SELECT 1 FROM SYS.SYSTABLE WHERE table_name = '$sanitizedName' AND table_type = 'VIEW'";
      break;
    case DatabaseType.sqlServer:
    case DatabaseType.postgresql:
      query = "SELECT 1 FROM information_schema.tables WHERE table_name = '$sanitizedName' AND table_type = 'VIEW'";
      break;
  }
  return _checkExists(query);
}