By the following query you will get the foreign key and primary key relationship between all the tables in database.
SELECT f.name AS ForeignKey,
SCHEMA_NAME(f.SCHEMA_ID) SchemaName,
OBJECT_NAME(f.parent_object_id) AS TableName,
COL_NAME(fc.parent_object_id,fc.parent_column_id) AS ColumnName,
SCHEMA_NAME(o.SCHEMA_ID) ReferenceSchemaName,
OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
COL_NAME(fc.referenced_object_id,fc.referenced_column_id) AS ReferenceColumnName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id
INNER JOIN sys.objects AS o ON o.OBJECT_ID = fc.referenced_object_id
Monthly Archives: October 2012
Get foreign key of a table in SQL
Get Primary key of a table in SQL
By the following query you will get column name of table in current database.
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE WHERE TABLE_NAME = ‘Table_Name’
LINQ In Javascript
By the following code you can use the LINQ in javascript.
For that you need JSLINQ.js file.
You will get it from http://jslinq.codeplex.com/releases/view/28886
<script type=”text/javascript” src=”JSLINQ.js”></script>
<script type=”text/javascript”>
function LINQInJavaScript() {
var myList = [
{ FirstName: “Chris”, LastName: “Pearson” },
{ FirstName: “Kate”, LastName: “Johnson” },
{ FirstName: “Josh”, LastName: “Sutherland” },
{ FirstName: “John”, LastName: “Ronald” },
{ FirstName: “Steve”, LastName: “Pinkerton” }
];
var whereExample1 = JSLINQ(myList).Where(function(item) { return item.FirstName == “Chris”; });
alert(whereExample1.items[0].FirstName);
</script>