March 23, 2008 at 9:53 pm
Hi
I am new in SQL server.
I am trying to find out which tables contain a specific column name in entire database.
Is there any equivalent dictionary as is in Oracle?
Thank you very much
March 23, 2008 at 10:47 pm
March 24, 2008 at 8:17 am
Even better than Oracle equivalents, there are implemented standards:
Select *
From INFORMATION_SCHEMA.COLUMNS
Where column_name = '{colName}'
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 24, 2008 at 4:17 pm
rbarryyoung resolved my issue and Anirban Paul helpped me learning more
Thank you both for the helps
March 24, 2008 at 5:05 pm
Glad I could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 24, 2008 at 10:21 pm
You are welcome and glad to know that my links where helpful.
😛
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply