Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find tables with specific field name?
Message
From
11/06/2008 11:19:21
Naomi Nosonovsky
Wisconsin, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Re: Find tables with specific field name?
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01323056
Message ID:
01323116
Views:
11
>No need of WHERE IN, INFORMATION_SCHEMA.COLUMNS has also TABLE_NAME :-)
>
>SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS
>WHERE COLUMN_NAME='My Field'
>
Good point, thanks.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform