topic RE: Regarding schema's in Product Forum

Regarding schema's

Meghanathammine — Thu, 09 Feb 2023 07:54:00 GMT

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
------------------------------

RE: Regarding schema's

EmersonF — Thu, 09 Feb 2023 16:00:00 GMT

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!
------------------------------

RE: Regarding schema's

Meghanathammine — Fri, 10 Feb 2023 07:52:00 GMT

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)

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

RE: Regarding schema's

EmersonF — Fri, 10 Feb 2023 13:44:00 GMT

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!
------------------------------