get schemas in a specific databse in ms sql server

Question

I need to get the schemas list in specific database in MS SQL server, not all schemas list in entire MS SQL server EX: i will get list of Db's like A,B,C from ms sql server.Now i need to fetch all schema list from A

I need a query for that can i get some help here

Answer 1

This can be accomplished using the sys.schemas catalog view:

USE A;
SELECT name 
FROM sys.schemas;

3-part name example:

SELECT name 
FROM A.sys.schemas;

Answer 2

You can obtain all schemas from specific database like this

USE Database_Name
SELECT * FROM sys.schemas

Read link below to have a better understanding

How do I obtain a list of all schemas in a Sql Server database