In this coding scenario, I am copying everything from TableA and pushing it into a new table called TableB in the same database and schema.
If you check the size of the database before and after you clone a table, it will be the same size – no matter the size of TableA. This is because, at this point in time, TableB exists only as a “pointer” to the data that constitutes TableA. It is not until something changes in one of the tables – say adding a row to TableA, that it stops being a “pointer” and is artificially constituted.
Read on to learn more about how this works.