Get XML schema from database schema (SQL Server 2008 diagram)

SQL Server Management Studio does not provide a way to do this.

Pasting the following into the code window gives you something close:

select * from INFORMATION_SCHEMA.COLUMNS for xml auto

      

        
        
        
      

    

Otherwise, the answer will be no, not without writing code or using an external tool.