SqlExpressionText

Classes > Nimblesite.DataProvider.Migration.Core > SqlExpressionText

Text helpers for comparing SQL expressions read back from database catalogs. Implements [MIG-VERIFY-BEFORE-UP-TO-DATE].

public static class SqlExpressionText

Methods

StripOuterParens(string)

public static string StripOuterParens(string sql)

Catalogs store defaults, filters and checks with or without redundant parentheses, e.g. (now()) vs now() or SQL Server's ((0)). Remove every pair that encloses the whole expression.

Parameters:

Name Type Description
sql String

Returns: String