Soft warning
As you approach a counted limit, Billing and the app show that you are close. Nothing is deleted.
Hard block
If workspaces, tables, records, users, automations, or storage exceed the plan, new creates that would go over are rejected. You can still open existing data, export, and change billing. Reduce usage or upgrade to write again.
File size and file count are separate caps on uploads. Hitting them does not hide tables.