Grouping tables in SQL SERVER

Question

How can I group a set of tables or mark them together?

In our project, each user has two separate tables allocated for them. I need to group all user tables separately.

How to do it?

Answer 1

Perhaps you could use SQL Server schemas to create a logical separation of database objects (tables, views, stored procedures, functions, triggers, etc.).

See the Microsoft Books online link: User Schema Separation

Using this method, you can group related tables into the same schema.

Answer 2

, , . .