I am working in Azure SQL Database. I want to find all Tables common to more than one database but have not been able to do so.
I am an "Admin" level User, but when I execute [select * from sys.tables]
in the master database I am not getting results for the 7 databases on the Azure server.
What is the method to select ALL Tables from all Databases in Azure SQL Database?
Run This query to list all the user tables and number of records in each of the table on SQL Azure DB
select t.name ,s.row_count from sys.tables t
join sys.dm_db_partition_stats s
ON t.object_id = s.object_id
and t.type_desc = ‘USER_TABLE’
and t.name not like ‘%dss%’
and s.index_id = 1
Server in Azure is logical server,It is not like Onpremises server..Things are logically grouped for making administration easier..Each database is a separate entity
so you need to execute sys.tables in each database to get data..There is one more feature called managed instance which is just like on premises server..
Check out this link to see which one is better for you
