DotNet-Jitendra(Asp.Net, C#, Sql Server, Linq, Ajax, Javascript, jQuery, Xml, MVC)
Menu
Home
SQL
jQuery
Linq
Ajax
MVC
Asp.Net Core
Tuesday, 30 September 2014
Find user defined database name in Sq l server
This query show the all user defined database name
select
[name]
from
master
.
dbo
.
sysdatabases
where
name
not
in
(
'master'
,
'tempdb'
,
'model'
,
'msdb'
)
Output:
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment