Thursday, October 22, 2015

How to find if a Column is used anywhere in the database

To get the table where this column use you can use this query.

 SELECT *  
 FROM sys.tables  
 WHERE tables.object_id IN (SELECT  
      OBJECT_ID  
 FROM sys.columns  
 WHERE columns.name LIKE '%CDRUGNAME%') -- use your column name  


vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link. http://www.microsoft.com/download...