Use ALTER TABLE statement to define the foreign key of a table. : ALTER TABLE « Table « SQL Server / T-SQL Tutorial

4> CREATE TABLE salesman(
5>         no INT NOT NULL UNIQUE,
6>         fname CHAR(20) NOT NULL,
7>         lname CHAR(20) NOT NULL,
8>         product_no CHAR(10))
9> GO
1> CREATE TABLE product(
2>         product_no CHAR(10) NOT NULL UNIQUE,
3>         product_name CHAR(20) NULL,
4>         price MONEY NULL)
5> GO
1> ALTER TABLE product
2>         ADD CONSTRAINT prim_prod PRIMARY KEY(product_no)
3> GO
1>
2>
3> ALTER TABLE salesman
4>         ADD CONSTRAINT prim_sales PRIMARY KEY (no),
5>         CONSTRAINT foreign_sales FOREIGN KEY(product_no)
6>         REFERENCES product
7> GO
1>
2> drop table salesman;
3> GO
1> drop table product;
2> GO
1>

3.2.ALTER TABLE
	3.2.1.	The basic syntax of the ALTER TABLE statement
	3.2.2.	drop column syntax
	3.2.3.	Change the length of the emp_name column in the employee table from varchar(30) to varchar(50)
	3.2.4.	Alter table to add a constraint based on IN function
	3.2.5.	Altering a Table: A Basic Form
	3.2.6.	Alter table to add column
	3.2.7.	Alter table to drop a column
	3.2.8.	The DROP COLUMN clause provides the ability to drop an existing column of the table.
	3.2.9.	ALTER data size for a COLUMN
	3.2.10.	Altering a Table: Enhanced Form
	3.2.11.	Use ALTER TABLE statement to define the primary key
	3.2.12.	Use ALTER TABLE statement to define the foreign key of a table.
	3.2.13.	Each declarative integrity constraint can be removed using the DROP clause of the ALTER TABLE statement.
	3.2.14.	Expanded nvarchar(20) to nvarchar(300)
	3.2.15.	Creating a Computed Column in alter table command
	3.2.16.	Create a Table Index