Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag DROP Rss

   Items 1 to 5 of 5   
 

Drop Any Object if it exists

This procedure drops any object if it exists not including temp tables.  Read more...
By Rob Sumsion 2014/07/29 | Source: SQLServerCentral.com | Category: drop
Rating: |  Discuss |   Briefcase | 1,154 reads

How to find user who ran DROP or DELETE statements on your SQL Server Objects

Someone has dropped a table from your database and you want to track who did it. Or someone has deleted some data from a table, but no one will say who did. In this tip, we will look at how you can use the transaction log to track down some of this information.   Read more...
By Additional Articles 2013/12/12 | Source: MSSQLTips.com | Category: sql server objects
Rating:  Rate this |   Briefcase | 6,228 reads

Drop FK For A Specific Table

Drop FK For A Sprecific Table  Read more...
By Danilo Antunez 2012/09/04 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,094 reads

Create/ drop unique key

This script will show you how to create/ drop unique key.  Read more...
By Michaƫl Hardman 2009/09/24 | Source: SQLServerCentral.com | Category: create
Rating: |  Discuss |   Briefcase | 642 reads

Drop FK For A Specific Table

Drop FK For A Sprecific Table  Read more...
By Danilo Antunez 2012/09/04 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,094 reads
   Items 1 to 5 of 5   
 
Tags
create (1)    
delete (1)    
foreign keys (fk) (1)    
objects (1)    
primary key (pk) (1)    
sql server 2005 (1)    
sql server objects (1)    
unique (1)