SQL Server/T-SQL/Transact SQL/schemas

system schemas

12>
13> create database mydb
14> GO
Msg 226, Level 16, State 5, Server sqle\SQLEXPRESS, Line 13
CREATE DATABASE statement not allowed within multi-statement transaction.
1>
2> SELECT v.name "View name",
3>     s.name "Schema name",
4>     DB_NAME() "mydb"
5> FROM sys.views v JOIN sys.schemas s
6> ON v.schema_id = s.schema_id
7> WHERE v.name = "myView"
8> GO
View name                                                                                                                        Schema name
                                                                              mydb
-------------------------------------------------------------------------------------------------------------------------------- -------------
----------------------------------------------------------------------------- ----------------------------------------------------------------
--------------------------
1>
2> drop database mydb
3> GO
Msg 574, Level 16, State 1, Server sqle\SQLEXPRESS, Line 2
DROP DATABASE statement cannot be used inside a user transaction.
1>
2>