New Transact SQL Video Tutorial: Rapid Database Development Using Database Diagrams (SQL Server 2000)

Rapid Database Development Using Database Diagrams (SQL Server 2000) - view details

This video tutorial shows you how to use the Enterprise Manager's Database Diagrams to create tables and manage constraints. Instead of having to manually create tables in the Enterprise Manager with the New Table dialog, you can use the Database Diagrams to do proof of concept and rapid database development (similar to rapid application development).

Highlights from this video:

• Customizing the Database Diagrams to include/exclude columns/metadata
• Adding Existing Tables to Layout
• Using the Save Change Script Option
• Explanations of what the asterisks mean in the Database Diagrams
• Create Foreign Keys Using the Drag-and-Drop features of the Database Diagrams

---

• Source: http://www.LearnTransactSQL.com
• Category: The Development Environment - Tools, Code Generation, and More
• Skill Level: 100 (Beginner)
• Length: 8:57 (5.36MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: hide columns, meta data, rad tool, rdd tool, beginner, beginning, for beginners, introduction, step by step