TSQL1.htm |
Objectives:
|
Step: 1 Start SQL Server
Connect, and appear at Object Explorer screen |
Step : 2 |
Step 2 Creating New DB
Click on OK |
Step ; 3 Create New Table |
Add columns and save as DEPT
and a view generated script to clip board USE [empdb1]
|
Open the table and fill out the cells
|
Step : creating EMP table Set a primary Key to EMPNO and Foreign key To deptno, using Relationship menu Adding relationship / foreign key
Note the relationship screen shot
|