is there any way to get all primary key and foreign key with below strucure of Database

You can check this link and make use of the code posted on this link, you need to create your own script using a loop so that it can run in all the databases

SQL SERVER – 2005 – List All The Constraint of Database – Find Primary Key and Foreign Key Constraint in Database

---

---

Everything about SQL Server | Experience inside SQL Server -Mohammad Nizamuddin