This script will find all foreign key contraints in the database it is run on. Includes.
Name of Foreign Key
Name of table FK is on
Name of column FK is on
Name of table FK references
Name of column FK references
selectso1.Name as FKConstraint, so.Name as FromTable, sc.Name as FromColumn, so2.Name as ToTable, sc1.Name as ToColumn From sysforeignkeys fk (nolock) JOINsysobjects so (nolock) on so.[id] = fk.fkeyid JOINsysobjects so1 (nolock) on fk.constid = so1.id joinsyscolumns sc (nolock) on fk.fkeyid = sc.id and fk.fkey = sc.colid JOINsysobjects so2 (nolock) on fk.rkeyid = so2.id joinsyscolumns sc1 (nolock) on fk.rkeyid = sc1.id and fk.rkey = sc1.colid --whereso.name = <Table Name>
It is used to show information from a database. It shows the creation date, it calculates the time in days, months and hours since its creation and it shows all the users with rights in that database.
2002-01-27
2,169 reads
Script that executes DBCC Checkdb in all databases, creates a log file in c:\Checkdb\ in a folder with the current date, and a file with the format: DB_Date.log Also sends each log in an attachment by Email.
2002-01-27
6,227 reads
When implementing a pilot study of audit trail triggers, you often want a way of removing all triggers in the database in order to retest your scripts: here it is!
2001-11-08
1,501 reads
Like the one posted before, the use of the SP is like this: proc_alerts 1,18. This will show the first 18 alerts on the system. OR proc_alerts 20,35 will show from 20 to 35. This lets you manage the list without letting go out of the screen.
2001-11-03
1,042 reads
If you are using OSQL or ISQL from DOS querys are really hard to use, because the result is to big for the screen. With this procedure, you can especify from wich column to wich column show the list of tables. For Example: proc_tables master, 3, 10 will show you only a short list of […]
2001-10-28
753 reads
