I need to create a stored procedure called spWhichTable that accepts a column name and returns the name of the table or tables that have a column by that name.
How would I go about doing this?
This is what I have so far but I'm not sure if it is right or not
CREATE PROC spWhichTable
Can someone please help me?