Difference between revisions of "Creating tables in SQL Server"
From MyWiki
| Line 11: | Line 11: | ||
ID int NOT NULL Primary Key,<br> | ID int NOT NULL Primary Key,<br> | ||
Gender nvarchar(50) NOT NULL,<br> | Gender nvarchar(50) NOT NULL,<br> | ||
| + | }<br> | ||
| − | + | Check the gui way of adding a foreign key constraint <br> | |
| − | + | ||
| − | + | ||
Revision as of 01:00, 3 September 2015
Alter table table1 add constraint <name of constraint>
FOREIGN KEY (<column>) references table2 (<primary key column>)
Foreign constraint prevents invalid data from being entered into the foreign key column. The foreign key value must be one of the values contained in the table it references.
Creating a table using sql
Use [Sample]
Create Table tblGender
{
ID int NOT NULL Primary Key,
Gender nvarchar(50) NOT NULL,
}
Check the gui way of adding a foreign key constraint
