CODEWITHSUNDEEP
sql-server-2005
Scott
Scott

Reputation: 590

Can I add sub folders to a SQL Server Management Studio Project?

What is the best way to keep large projects organized with SSMS?

I want to do something like:

ProjectRoot
    SchemaObjects
        Tables
            Constraints
            Indexes
            Keys
        Functions
        Views
        Stored Procedures
     Scripts
         DataGeneration

And so on, but I cannot find a nice way to do this... Any suggestions?

Upvotes: 4

Views: 2586

Answers (2)

mrdenny
mrdenny

Reputation: 5078

Sadly there isn't. Maintain your object scripts out side of SSMS and simply edit them in SSMS.

IMHO this is one thing that is lacking big time in SSMS.

Upvotes: 3

Geoff
Geoff

Reputation: 8850

I don't think there's anyway way to do this in SMSS, at least not in 2005. Maybe a third party tool will give you this; there's a list of replacements for 2000 Enterprise Manager here; not the most current, but probably a good starting point.

Upvotes: 3

Related Questions