Regarding schema's

[Meghanathammine]

I am trying to fetch some object names but only related to dbo schema names are getting fetched for all other it is showing as blank values in process whereas in SSMS it is fetching full data related to all schema's but not in process.

------------------------------
Meghana thammineni
------------------------------

[EmersonF]

Hey, Let me know if you have sure that you have permission for this.

Hmm, Can you giveme the query used too? 

------------------------------
Emerson Ferreira
Cons, Intelligent automation
Avanade Brasil
Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------

[Meghanathammine]

I guess it is not related to access issue as for the same query it is fetching every schema name in SSMS .

Query Used Below:-

"select schema_name(schema_id)+'.'+name as TYPE_TABLE from Database.sys.types where is_user_defined=1:" 

(Query Source from google)

---------------------------------------------------------

[EmersonF]

Stranger,  it's work for me 😕 

So, another alternative is,  use  this query " select schema_name(schema_id)+'.'+name as TYPE_TABLE, is_user_defined from Database.sys.types" and filter the colection where is_user_defined = 1 its should work for you

------------------------------
Emerson Ferreira
Cons, Intelligent automation
Avanade Brasil
Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------