Feeds:
Posts
Comments

Posts Tagged ‘Find Column in entire Database’

To find a column name in entire database  and then generate SELECT
script on all those tables

 

SELECT

‘SELECT * FROM’+‘ ‘+NAME+‘ ‘

FROM
sys.tables

WHERE
object_id in

(

SELECT
object_id FROM
sys.columns

WHERE
NAME=‘ColumnName’

)

Read Full Post »

%d bloggers like this: