Visual Studio Database Designer
I am working on an ASP Web Application. I can add a connection to my SQL
Server database in my Server Explorer in Visual Studio.NET Beta2, see all
the tables, modify records, etc. However, I can't find any button or option
to work with my database design (e.g. add tables, add table fields, etc.)
Where is the "Database Designer" in Visual Studio?!?!
thanks a bunch
Re: Visual Studio Database Designer
> I can add a connection to my SQL Server database in my Server
> Explorer in Visual Studio.NET Beta 2, see all the tables, modify
> records, etc. However, I can't find any button or option to work
> with my database design (e.g., add tables, add table fields, etc.)
Kuski: In Server Explorer, expand the tree under the database you want to
work with. To add a table, right-click on the Tables node and select "New
Table." To edit the design of a table (add/delete columns, etc.), expand the
Tables node, right-click on the table you want to edit, and select "Design
If you're unable to do the above, make sure you're logged into your SQL
Server as 'sa' or another user with "database owner" privileges.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL