How To List the dependent objects of defaults 
Author Message
 How To List the dependent objects of defaults
Hi Every one.
  Please help me how to list the depndent objects of defaults and rules.I
know we can use sp_depends but it is working fine for tables and view.But
not for default and rules.Defaults and rules also objects of sqlserver.

From
Ramki



Wed, 10 Jul 2002 03:00:00 GMT
 How To List the dependent objects of defaults

Ramki,

Try sp_helpconstraint. Defaults and rules are objects bound to specific
tables.

HTH,

JP


Quote:
> Hi Every one.
>   Please help me how to list the depndent objects of defaults and rules.I
> know we can use sp_depends but it is working fine for tables and view.But
> not for default and rules.Defaults and rules also objects of sqlserver.

> From
> Ramki




Thu, 11 Jul 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Dependent objects script is empty although many dependent objects exist

2. SQL Server Copy Object Task: include dependent objects

3. Create a list of Dependent Tables and Parent Tables

4. List a tables dependent views.

5. field dependent value lists

6. Update from object types with type or table dependents

7. SQL 7.0 Generate SQL Scripts with Dependent Objects

8. Access right inheritance (for dependent objects)

9. DTS Dependent Objects

10. Update from object types with type or table dependents

11. Finding dependent objects in different DB

12. Dependent Objects in scripts


 
Powered by phpBB® Forum Software