Thanks Eirikur Eiriksson , it helped a lot .. 🙂

Thanks Luis , for clarifying .. 🙂

But when i was executing the query its showing error ,

ERROR : The "The type of column "database_id" conflicts with the type of other...

Can we write dynamically for sys.databases , is there any possibility ?

But for other tables it is possible by using sys.columns and then we can unpivot it.

but sys.databases is a...