How to search a column name in all tables in a database in SQL Server 2012?

Joe Mike

Is it possible to search like below:

Like '%tax%'
Azar

Try the below

Select distinct object_name(object_id), name from sys.columns where name like '%tax%'

or

select table_name, Column_name from Information_Schema.Columns where Column_Name like '%Tax%'

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0

関連記事

分類Dev

How to search all tables in a database?

分類Dev

SQL Search All Tables

分類Dev

Move database from SQL Server 2012 to 2008

分類Dev

Merge data into one column - sql server 2012

分類Dev

Multiple tables with the same name in SQL Server

分類Dev

SQL Server 2012 Full Text Search match results

分類Dev

How to check history in SQL Server 2012?

分類Dev

Bulk insert into the SQL Server 2012 database - C#

分類Dev

Change collations of all columns of all tables in SQL Server

分類Dev

Replace and delete column values in SQL Server database

分類Dev

How to insert data into database with column name "default"

分類Dev

Copy tables from one database to another in SQL Server

分類Dev

How does an OLEDB/ODBC connection know the path to a SQL Server database by name only?

分類Dev

How do you truncate all tables in a database using TSQL?

分類Dev

How to get COUNT(*) from one partition of a table in SQL Server 2012?

分類Dev

How to retrieve only particular part of string in SQL Server 2012

分類Dev

How to count row in SQL SERVER 2012 using sys.partitions

分類Dev

How to store sql column name in form value

分類Dev

Drop all tables in a database in CockroachDB

分類Dev

Export SQL Server 2014 database (2008 compatible) in a backup file compatible with 2012

分類Dev

Numbering islands in SQL Server 2012

分類Dev

SQL Server 2012 Pivot Table

分類Dev

Restore SQL Server 2012 error

分類Dev

How to setup SSRS with an Azure SQL Server Database

分類Dev

How to import huge blob into SQL Server database?

分類Dev

Disable and re-enable all indexes in a SQL Server database

分類Dev

Drop all objects in SQL Server database that belong to different schemas?

分類Dev

How should we name or map SQL tables from Postgres to Node?

分類Dev

SELECT.. WHERE NOT IN.. all of a sudden isn't working in SQL SERVER 2012

Related 関連記事

  1. 1

    How to search all tables in a database?

  2. 2

    SQL Search All Tables

  3. 3

    Move database from SQL Server 2012 to 2008

  4. 4

    Merge data into one column - sql server 2012

  5. 5

    Multiple tables with the same name in SQL Server

  6. 6

    SQL Server 2012 Full Text Search match results

  7. 7

    How to check history in SQL Server 2012?

  8. 8

    Bulk insert into the SQL Server 2012 database - C#

  9. 9

    Change collations of all columns of all tables in SQL Server

  10. 10

    Replace and delete column values in SQL Server database

  11. 11

    How to insert data into database with column name "default"

  12. 12

    Copy tables from one database to another in SQL Server

  13. 13

    How does an OLEDB/ODBC connection know the path to a SQL Server database by name only?

  14. 14

    How do you truncate all tables in a database using TSQL?

  15. 15

    How to get COUNT(*) from one partition of a table in SQL Server 2012?

  16. 16

    How to retrieve only particular part of string in SQL Server 2012

  17. 17

    How to count row in SQL SERVER 2012 using sys.partitions

  18. 18

    How to store sql column name in form value

  19. 19

    Drop all tables in a database in CockroachDB

  20. 20

    Export SQL Server 2014 database (2008 compatible) in a backup file compatible with 2012

  21. 21

    Numbering islands in SQL Server 2012

  22. 22

    SQL Server 2012 Pivot Table

  23. 23

    Restore SQL Server 2012 error

  24. 24

    How to setup SSRS with an Azure SQL Server Database

  25. 25

    How to import huge blob into SQL Server database?

  26. 26

    Disable and re-enable all indexes in a SQL Server database

  27. 27

    Drop all objects in SQL Server database that belong to different schemas?

  28. 28

    How should we name or map SQL tables from Postgres to Node?

  29. 29

    SELECT.. WHERE NOT IN.. all of a sudden isn't working in SQL SERVER 2012

ホットタグ

アーカイブ