What is this query for?

Question

Hi. What does this query return? select * from sysdatabases where sid 0x01 order by name

Scott Lysle · Answer

To get a list of non system databases from a server instance

Kunal Naik · Answer

Hi Yes it will return all the database names as well as other information of the database like dbid sid filename version etc. It is used to getting information of all those databases which are created in sql server except system databases.

Aarti · Answer

Hi Nethra select * from sysdatabases where sid 0x01 order by name This gives all non system databases informations like nameFilenameversion status... etc. Thanks.

Nethra R S · Answer

Hi Suppose i have some 50 databases.. Will it return all the database names? Why is it used and where? In what situations?

Arjun Panwar · Answer

Hi Nethra R S this query is used To get the database names.

Nethra R S · Answer

Hi Does it give all the database names?