WebSep 21, 2010 · select table_name from information_schema.columns where column_name = '' Using the information_schema views is 'more correct' as system details in the system databases are subject to change between implementations of SQL Server. WebMar 11, 2011 · This will get you the list. select * from information_schema.columns where table_name='table1' and column_name like 'a%'. If you want to use that to construct a query, you could do something like this: declare @sql nvarchar (max) set @sql = 'select ' select @sql = @sql + ' [' + column_name +'],' from information_schema.columns …
SQL query to get column names if it has specific value
WebJan 20, 2015 · The column_name, table_name, and owner represent the includes box I use, though you may find others away use. If you want to search for tables in ampere particular schema based on file general, you would set the owner to the name of your schema in aforementioned where contract. WebJul 13, 2024 · 18. You can query the database's information_schema.columns table which holds the schema structure of all columns defined in your database. Using this query: select * from information_schema.columns where column_name = 'ProductNumber'. The result would give you the columns: TABLE_NAME, TABLE_CATALOG, DATA_TYPE … lienzo odyssey planning
How to find column names for all tables in all databases in SQL …
WebApr 28, 2010 · I guess 5 years ago zach did not make it clear to you the problem with this query. The question asks how to get the information across all DBs -- your answer is DB specific -- the first one will query the current DB and the second will query a named DB. WebJan 22, 2024 · Here is the script which can help us to identify any column with the column name from the database. SELECT OBJECT_SCHEMA_NAME(ac.object_id) SchemaName, OBJECT_NAME(ac.object_id) TableName, ac.name as ColumnName, tp.name DataType FROM sys.all_columns ac INNER JOIN sys.types tp ON tp.user_type_id = … mcm backpacks replica