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

1 vote336 views1 answer
Sql select table header
SQL
21 votes397 views6 answers
Update sql
SQL
0 vote350 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
7 votes336 views2 answers
N highest salary in sql
SQL
1 vote358 views1 answer
Postgresql export output table as a csv
SQL
0 vote340 views1 answer
Min salary in sql
SQL
0 vote360 views1 answer
Mysql insert into select transaction c#
SQL
2 votes356 views4 answers
Mysql select into new table
SQL
0 vote398 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
1 vote345 views1 answer
Substr sql last character
SQL