SQL Azure - How can I select sysdatabases table from master database in SQL Azure?

Question

In SQL Azure, I try this:

select * From master.dbo.sysdatabases

And get this error:

Reference to database and/or server name in 'master.dbo.sysdatabases' is not supported in this version of SQL Server

What should I do to be able to run that query in SQL Azure?

Answer 1

You use the system view sys.databases (without the master qualification, it is not needed)

The system table sysdatabases has been deprecated since SQL Server 2005 (Azure is a later version) and in any case is not supported on Azure