Select table column name in sql

Find table from column name in sql

SELECT      c.name  AS 'ColumnName'
            ,t.name AS 'TableName'
FROM        sys.columns c
JOIN        sys.tables  t   ON c.object_id = t.object_id
WHERE       c.name LIKE '%MyName%'
ORDER BY    TableName
            ,ColumnName;

Source: stackoverflow.com

Select table column name in sql

/**
You must have all privillage to access this, else it will denaid access :)
**/

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'tableName';

Similar codes

0 vote166 views1 answer
How to stop all connections to a psql 12 database?
SQL
1 vote168 views1 answer
Mysql sort by date column
SQL
9 votes153 views2 answers
Cmd to rename a collumn name in sql
SQL
1 vote168 views1 answer
Calculate age in sql postgresql
SQL
0 vote171 views1 answer
Oracle running queries sql
SQL
1 vote161 views2 answers
Mysql update table from another table
SQL
11 votes187 views3 answers
How to get last row of table in sql
SQL
16 votes174 views2 answers
Oracle ddl
SQL
0 vote173 views1 answer
Sqlite3 update select
SQL
1 vote174 views1 answer
How to see which columns are indexxed mysql
SQL