General information
Forum:
Microsoft SQL Server
Dmitry,
Try this:
select sobj.name as ctblname, syscol.name as ccolname
from syscolumns syscol
left outer join sysobjects sobj on syscol.id = sobj.id
where sobj.type = 'U' and charindex('XYZ', syscol.name) > 0
order by 1,2
>Is there a command that would tell you which tables have a field/column name "XYZ" or which field names contain "XYZ"?
>
>Thank you.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only