Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to find all field XYZ in all tables
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00952792
Message ID:
00952823
Views:
8
>>>Is there a command that would tell you which tables have a field/column name "XYZ" or which field names contain "XYZ"?
>>>
>>You can use INFORMATION_SCHEMA.
SELECT * FROM pubs.INFORMATION_SCHEMA.COLUMNS
>>	WHERE column_name LIKE '%id%'
>
>Thank you very much, Sergey. I will follow your suggestion.

You're welcome.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform