public static string GetKeys(this SqlProductInfo productInfo) { if (productInfo.IsSql2005OrNewer) { return(Constants.SQL_GetKeys2005); } return(Constants.SQL_GetKeys); }
public static string GetExtendedData(this SqlProductInfo productInfo) { if (productInfo.IsSql2005OrNewer) { return(Constants.SQL_GetExtendedData2005); } return(Constants.SQL_GetExtenedData); }
public static string GetColumnConstraintsWhere(this SqlProductInfo productInfo) { if (productInfo.IsSql2005OrNewer) { return(" WHERE SCHEMA_NAME([t].[schema_id]) = @SchemaName AND [t].[name] = @TableName AND [c].[name] = @ColumnName"); } return(" AND [stbl].[name] = @SchemaName AND [tbl].[name] = @TableName AND [clmns].[name] = @ColumnName"); }
public static string GetAllTableColumns(this SqlProductInfo productInfo) { if (productInfo.IsSql2005OrNewer) { return(Constants.SQL_GetAllTableColumns2005); } return(Constants.SQL_GetAllTableColumns); }
public static string GetAllCommandParameters(this SqlProductInfo productInfo) { if (productInfo.IsSql2005OrNewer) { return(Constants.SQL_GetAllCommandParameters2005); } return(Constants.SQL_GetAllCommandParameters); }
public static string GetIndexes(this SqlProductInfo productInfo) { if (productInfo.IsSqlAzure) { return(Constants.SQL_GetIndexesAzure); } if (productInfo.IsSql2005OrNewer) { return(Constants.SQL_GetIndexes2005); } return(Constants.SQL_GetIndexes); }
public static string GetExtendedProperties(this SqlProductInfo productInfo) { return(Constants.SQL_GetExtendedProperties); }