SQL Server/T-SQL/System/views

system views

   <source lang="sql">

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>

      </source>