Which schema is used in Which Object

--To find out which database schemas(dbo.data_reader,data_writer,lhi\ramesh) are used in which object
We can find out that by running this query.
SELECT SS.NAME,SO.NAME as ObjectName,SO.Type,SO.SCHEMA_ID
FROM SYS.OBJECTS SO INNER JOIN SYS.SCHEMAS SS
ON SO.SCHEMA_ID=SS.SCHEMA_ID
WHERE SS.Name LIKE 'dbo'
ORDER BY Type

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server