Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 deleting default objects

Author  Topic 

manikandan
Starting Member

35 Posts

Posted - 2001-04-24 : 07:15:08
Hello

I've created a default object and the object is associated with the columns of several tables. Now, i tried to drop the default. Naturally it didn't allow me saying that the default is bound to columns. So i've to unbind the relation using sp_unbindefault. But the problem for me is that i don't the columns(tables) that are associated with the default. How do i find out the columns that are associated with the default. What are the relations that i've to look for. Could anyone send me the sql to do that.

Your help will be appreciated.

cheers
manikandan

Cheers
Manikandan
   

- Advertisement -