• A text editor is the minimum you need to create a new schema (CREATE TABLE abc ...). 🙂

    SSMS has a totally crappy ability to do this graphically (see the Database Diagram's functionality in BOL and the folder in SSMS).

    Visio Professional can do database schemas.

    My preferred tool BY FAR though is Embarcadero's ERStudio.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service