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

Scripts by Vidyadhar Pandekar

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

Changing Foreign key names to standard naming convention across the DB

Rename the Foreign keys to standard notation - FK_childTable_ParentTable  Read more...
By Vidyadhar Pandekar 2010/02/24 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,112 reads

Changing Primary key names to standard naming convention across the DB

This script will rename the Primary keys to standard notation - PK_TableName  Read more...
By Vidyadhar Pandekar 2011/07/29 | Source: SQLServerCentral.com | Category: rename primary key
Rating: |  Discuss |   Briefcase | 1,632 reads

Truncate Table Partition command in SQL Server

Procedure to automatically truncate table partition   Read more...
By Vidyadhar Pandekar 2014/01/20 | Source: SQLServerCentral.com | Category: truncate table
Rating: |  Discuss |   Briefcase | 7,155 reads
   Items 1 to 5 of 5