Find all tables containing column with specified name – MS SQL Server

Is it possible to query for table names which contain columns being

LIKE '%myName%'

?

Related Posts:

  1. Selecting COUNT(*) with DISTINCT
  2. What is a stored procedure?
  3. Inserting multiple rows in a single SQL query? [duplicate]
  4. Self Join to get employee manager name
  5. How do I UPDATE from a SELECT in SQL Server?
  6. SQL query to select dates between two dates
  7. When should I use CROSS APPLY over INNER JOIN?
  8. How can I do an UPDATE statement with JOIN in SQL Server?
  9. T-SQL split string
  10. How do I escape a single quote in SQL Server?
  11. T-SQL split string based on delimiter
  12. How do I perform an IF…THEN in an SQL SELECT?
  13. How do I escape a single quote in SQL Server?
  14. IDENTITY_INSERT is set to OFF – How to turn it ON?
  15. SQL Server : Arithmetic overflow error converting expression to data type int
  16. How to calculate percentage with a SQL statement
  17. Column name or number of supplied values does not match table definition
  18. When to use SELECT … FOR UPDATE?
  19. SQL Server FOR EACH Loop
  20. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  21. How to join two tables by multiple columns in SQL?
  22. Query error with ambiguous column name in SQL
  23. Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint
  24. DateTime2 vs DateTime in SQL Server
  25. How to group by month from Date field using sql
  26. How can I get column names from a table in SQL Server?
  27. Is there a combination of “LIKE” and “IN” in SQL?
  28. How to parse XML data in SQL server table
  29. What is the equivalent of ‘describe table’ in SQL Server?
  30. Error converting data type varchar to float
  31. I want to use CASE statement to update some records in sql server 2005
  32. What represents a double in sql server?
  33. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  34. SELECT DISTINCT on one column
  35. Exclude a column using SELECT * [except columnA] FROM tableA?
  36. Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
  37. TSQL PIVOT MULTIPLE COLUMNS
  38. How to format a numeric column as phone number in SQL
  39. SQL “select where not in subquery” returns no results
  40. Equivalent of Oracle’s RowID in SQL Server
  41. SQL: IF clause within WHERE clause
  42. Is it possible to specify condition in Count()?
  43. SQL Server dynamic PIVOT query?
  44. Error converting data type varchar
  45. Temporary table in SQL server causing ‘ There is already an object named’ error
  46. I want to use CASE statement to update some records in sql server 2005
  47. How to calculate age (in years) based on Date of Birth and getDate()
  48. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  49. Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
  50. How can I group by date time column without taking time into consideration
  51. “select * into table” Will it work for inserting data into existing table
  52. SUM OVER PARTITION BY
  53. Update query using Subquery in Sql Server
  54. Varchar invalid for Sum operator
  55. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  56. Case in Select Statement
  57. Must declare the scalar variable
  58. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  59. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  60. What is the use of GO in SQL Server Management Studio & Transact SQL?
  61. Drop a temporary table if it exists
  62. What does SQL Select symbol || mean?
  63. Each GROUP BY expression must contain at least one column that is not an outer reference
  64. Why does NULL = NULL evaluate to false in SQL server
  65. Best way to do nested case statement logic in SQL Server
  66. Get day of week in SQL Server 2005/2008
  67. Each GROUP BY expression must contain at least one column that is not an outer reference
  68. mysql Foreign key constraint is incorrectly formed error
  69. incorrect syntax error CREATE VIEW must be the only statement in the batch
  70. Why use a READ UNCOMMITTED isolation level?
  71. SQL Server reports ‘Invalid column name’, but the column is present and the query works through management studio
  72. SQL Server String or binary data would be truncated
  73. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  74. Remote table-Valued Function Calls are not allowed
  75. What is the Oracle equivalent of SQL Server’s IsNull() function?
  76. MS SQL compare dates?
  77. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  78. Get size of all tables in database
  79. Why is SQL server throwing this error: Cannot insert the value NULL into column ‘id’?
  80. SQL statement not working – “Operand type clash: date is incompatible with int’
  81. SQL – WHERE (X, Y) IN (A, B)
  82. ListAGG in SQLSERVER
  83. Format number as percent in MS SQL Server
  84. How can I search (case-insensitive) in a column using LIKE wildcard?
  85. ‘CREATE PROCEDURE’ must be the only statement in the batch (Erro)
  86. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  87. Solutions for INSERT OR UPDATE on SQL Server
  88. Append table to an existing one: SQL Server
  89. SQL Server – An expression of non-boolean type specified in a context where a condition is expected, near ‘RETURN’
  90. CASE IN statement with multiple values
  91. Using Excel VBA to run SQL query
  92. Pad a string with leading zeros so it’s 3 characters long in SQL Server 2008
  93. wpdb->prepare function remove single quote for %s in SQL statment
  94. How to get INSERT errors from $wpdb?
  95. MySQL query for taxonomy-meta
  96. Find locations of all featured images of draft posts via SQL
  97. How to show result of sql query in a page?
  98. How to change link in all posts?
  99. Delete posts with word count less than x number of words
  100. SQL command to export post_content from wp_posts using phpMyAdmin

Leave a Comment