{[['
']]}

Query to Find Column From Database
Find Column From All Tables of Database
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%ColumnName%'
ORDER BY schema_name, table_name;
Find Column From All views of Database
SELECT t.name AS view_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.views AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%ColumnName%'
ORDER BY t.name
Really find the Column
select
s.[name] 'Schema',
t.[name] 'Table',
c.[name] 'Column',
d.[name] 'Data Type',
d.[max_length] 'Max Length',
d.[precision] 'Precision',
c.[is_identity] 'Is Id',
c.[is_nullable] 'Is Nullable',
c.[is_computed] 'Is Computed',
d.[is_user_defined] 'Is UserDefined',
t.[modify_date] 'Date Modified',
t.[create_date] 'Date created'
FROM sys.schemas AS s INNER JOIN
sys.tables AS t ON s.schema_id = t.schema_id INNER JOIN
sys.columns AS c ON t.object_id = c.object_id INNER JOIN
sys.types AS d ON c.user_type_id = d.user_type_id
WHERE (c.name LIKE '%ColumnName%')
select owner,table_name from all_tab_columns where upper(column_name) like upper('%keyword%');
select owner, table_name, column_name
from all_tab_columns
where column_name in ('ID', 'NAME', 'NAME', 'ADDRESS');
Post a Comment