This script help to get list of all objects associated with a particular schema.
This can be useful when you want to get all objects for a project to be migrated from one environment to another, but instead of going through each item, one can use the mentioned script and get all objects in matter of seconds.
SELECT name, [type], type_desc FROM sys.objects
WHERE schema_Name(schema_id) = 'dbo'
AND type IN ('U', 'V', 'FN', 'TF', 'TT', 'P')
--U - User Table
--V - View
--FN - Scalar Valued Function
--TF - Table Valued Function
--TT - Table Type
--P - Stored Procedure 
2014-03-31
1,926 reads
2014-03-12
1,861 reads
Use this script to find all the Foriegn Keys and their details in a database
2013-09-11 (first published: 2013-09-02)
1,408 reads
2012-12-07
2,123 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