Creating tables in SQL Server - Revision history

George2 at 01:11, 3 September 2015

2015-09-03T01:11:18Z

2015-09-03T01:00:45Z

2015-09-03T00:53:32Z

2015-09-03T00:51:04Z

2015-09-03T00:50:07Z

2015-09-03T00:49:52Z

2015-09-03T00:41:56Z

2015-09-03T00:39:38Z

Created page with "Alter table table1 add constraint <name of constraint> <br> FOREIGN KEY (<column>) references table2 (<primary key column>)<br>"

New page

Alter table table1 add constraint <name of constraint> <br>
FOREIGN KEY (<column>) references table2 (<primary key column>)<br>

← Older revision		Revision as of 01:11, 3 September 2015
Line 14:		Line 14:

	Check the gui way of adding a foreign key constraint <br>		Check the gui way of adding a foreign key constraint <br>
		+
		+	Difference between nvarchar and varchar :<br>
		+	'''varchar:''' Variable-length, non-Unicode character data. The database collation determines which code page the data is stored using.<br>
		+	'''nvarchar:''' Variable-length Unicode character data. Dependent on the database collation for comparisons.<br>

@@ Line 11: / Line 11: @@
 ID int NOT NULL Primary Key,<br>
 Gender nvarchar(50) NOT NULL,<br>
+Check the gui way of adding a foreign key  constraint <br>
-−
-−

@@ Line 6: / Line 6: @@
 '''Creating a table using sql'''<br>
 Create Table tblGender<br>
 {<br>

@@ Line 6: / Line 6: @@
 '''Creating a table using sql'''<br>
-Create Table tblGender
+Create Table tblGender<br>
+{<br>
-ID int NOT NULL Primary Key,
+ID int NOT NULL Primary Key,<br>
-Gender nvarchar(50) NOT NULL,
+Gender nvarchar(50) NOT NULL,<br>
+}

@@ Line 4: / Line 4: @@
 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<br>
+'''Creating a table using sql'''<br>
 Create Table tblGender

← Older revision		Revision as of 00:49, 3 September 2015
Line 3:		Line 3:

	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.		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<br>
		+
		+	Create Table tblGender
		+	{
		+	ID int NOT NULL Primary Key,
		+	Gender nvarchar(50) NOT NULL,
		+
		+
		+
		+	}

← Older revision		Revision as of 00:41, 3 September 2015
Line 1:		Line 1:
	Alter table table1 add constraint <name of constraint> <br>		Alter table table1 add constraint <name of constraint> <br>
	FOREIGN KEY (<column>) references table2 (<primary key column>)<br>		FOREIGN KEY (<column>) references table2 (<primary key column>)<br>
		+
		+	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.