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

Using "Script DROP and CREATE" you will get DROP followed by CREATE table and then CREATE Fks.

This way, you can change the datatypes in the CREATE table too.

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.