How to check if table exists in a migration?

Question

This is as close as I've got...

public static class Helpers
{
    public static bool TableExists(this MigrationBuilder builder, string tableName)
    {
        bool exists = builder.Sql($@"SELECT 1 FROM sys.tables AS T
                     INNER JOIN sys.schemas AS S ON T.schema_id = S.schema_id
                     WHERE S.Name = 'SchemaName' AND T.Name = '{tableName}'");

        return exists;
    }

}

But how does one get a result form the SQL call?

Answer 1

It's not a perfect solution, but you could use an IF in SQL:

builder.Sql(@"
    IF (EXISTS(SELECT * 
        FROM INFORMATION_SCHEMA.TABLES
        WHERE TABLE_SCHEMA = 'MySchema'
        AND  TABLE_NAME = 'TableName'))
    BEGIN
        --DO SOMETHING
    END
");