All geek questions in one place

Subcircuits in SQL Server 2005/2008

This is a simple question, but I could not find any information about this.

Is it possible to have sub-schemas in SQL Server 2005/2008?

Example: The presence of the HR (Human Resources) schema with the "Learning" subcircuit (with tables associated with it). It will look like HR.Training.*where the *tables are.

+3
source share
4 answers

No. You can fake this with roles by placing different users in different roles and letting these roles use objects.

+5
source

Perhaps you could fake it in the name of the scheme, for example HR_Training. * and HR_Reviews. * etc. Chasey, I know.

+2

Oracle? , Oracle . SQL Server .

SQL-,

e. server.database.owner.object

HRSvr.HR.dbo.xxx HRSvr.Training.dbo.xxxx.

+1

, , , . IBM db2, - , "dbo".

+1

Source: https://habr.com/ru/post/1739132/

More articles:


All Articles