What are you looking for ?
Home » » Column Name

Column Name

{[['']]}

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%')


Find Column in Oracle Database


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');
Share this article :

Post a Comment

Flag Counter

Social Profile

 
Copyright x 2011. By Wael Medhat - All Rights Reserved