This procedure will give the list of columns included in the primary key for a given table of given database on given server.For. e.g.Get_PrimaryKey 'vrs-118','Demo_StDB','IMAGEREPOSITORY'
2007-02-14 (first published: 2006-08-25)
941 reads
This script will create two views and select the data from the TableReferences view. This view will give list of all the foreignkeys of the selected database with its constraint name, the table name and column name(s) on which the constraint is created and the referencing table name and column name(s).
2006-09-25 (first published: 2006-08-25)
590 reads
By SQLPals
Get Configuration Change History From the SQL Server Error Logs There...
By SQLPals
How To Gain Access To SQL Server When No DBA ...
Hi, I need to design a data warehouse solution to manage medical records about...
Comments posted to this topic are about the item Gentlest of Reminders, Don't Stop...
Gurus, there is a table which is very slow to query , it has...
Ask SSC