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