How to validate the structure of a table?

I want to validate the structure of a table and this simple test fails even though I expected it to pass. What needs to change?

EXEC tSQLt.NewTestClass 'MyTests';
GO

CREATE PROCEDURE [MyTests].[test Some test]

AS
BEGIN
    -- Assemble
    CREATE TABLE #Expected (id INT);

    -- Act

    -- Assert
    EXEC tSQLt.AssertEqualsTableSchema #Expected, 'dbo.MyTable';
END;
GO

CREATE TABLE dbo.MyTable (id INT);

GO

-- Result:

Test Procedure: [test].[MyTests].[test Some test] on ...
[MyTests].[test Some test] failed: (Failure) Unexpected/missing column(s)
|_m_|name|RANK(column_id)|system_type_id|user_type_id|max_length|precision|scale|collation_name|is_nullable|is_identity|
+---+----+---------------+--------------+------------+----------+---------+-----+--------------+-----------+-----------+
|>  |id  |1              |56[int]       |56[int]     |4         |10       |0    |!NULL!        |True       |!NULL!     |

I haven’t tried this, but what if you compare the temp table to another temp table?  You can do this.

 

SELECT * FROM dbo.MyTable

INTO #Actual

 

tSQLt.AssertEqualsTableStructure #Expected, #Actual

To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/CAJ1xV3jYQwLs42Vxwg5fPfXN0wrJ%3DV0OtsrzO0kYPzxsJXrVhQ%40mail.gmail.com.

Using two standard tables or using two temporary tables works well.

    -- Act
    SELECT *
    INTO #Actual
    FROM dbo.MyTable

    -- Assert
    EXEC tSQLt.AssertEqualsTableSchema #Expected, #Actual;
END;
GO