Searching Column Names in SQL Tables

Published by david on

A small query to search for the names of columns in all SQL tables

?
1
2
3
4
5
6
SELECT      c.name  AS 'ColumnName'
            ,t.name AS 'TableName'
FROM        sys.columns c
JOIN        sys.tables  t   ON c.object_id = t.object_id
WHERE       c.name LIKE '%RECHERCHE%'
ORDER BY    TableName,ColumnName;

Categories: SQL
Tags:

0 Comments

Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts

SQL

SQL and MDT: Firewall Configuration

Configure your firewall for SQL and MDT integration

SQL

Database Optimization: Purging SQL Logs (LDF)

Learn how to optimize your SQL database by purging logs (LDF). Reduce your log file size and enhance your database performance.

SQL

How to Modify Over 200 Rows in SQL Management Studio

Learn the step-by-step process to efficiently modify more than 200 rows in SQL Management Studio. Discover how to adjust settings in the SQL Server Object Explorer to increase the default row limit