The script will show the details of all the FKs in a particular database. Open SSMS and run the script for the intended database. In the script I have used Adventureworks2012 as an example. You can replace that with your required DB name
USE AdventureWorks2012 go SELECT fk.name AS ForeignKey, IsNotForReplication = case when fk.is_not_for_replication = 0 then 'No' else 'yes' end, OBJECT_NAME(fk.parent_object_id) AS TableName, COL_NAME(fkc.parent_object_id, fkc.parent_column_id) AS ColumnName, OBJECT_NAME (fk.referenced_object_id) AS ReferenceTableName, COL_NAME(fkc.referenced_object_id, fkc.referenced_column_id) AS ReferenceColumnName FROM sys.foreign_keys AS fk INNER JOIN sys.foreign_key_columns AS fkc ON fk.OBJECT_ID = fkc.constraint_object_id order by IsNotForReplication
2014-03-31
1,932 reads
2014-03-12
1,866 reads
2012-12-07
2,126 reads
This helps to get list of all objects in a particular schemas.
2012-08-13 (first published: 2012-08-08)
1,116 reads
In a previous tip, Granting limited permissions to create views in another schema in SQL Server, I showed how to use the CREATE VIEW permission and the ALTER SCHEMA permission to allow users to create new views using the same schema as the tables. However, I have found that the users can alter and drop tables in this schema which is beyond what I want them to do. A DENY CREATE TABLE does not work, so what can I do to prevent them from touching the tables in this way? In this tip I will show you how you can use a DDL trigger to prevent this unneeded access.
2009-08-17
3,444 reads
