Sql

Search

find column name in database

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 '%columnName%'
ORDER BY    TableName
            ,ColumnName;

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql count grouped rows
Sql :: cannot pip install mysqlclient
Sql :: connect python to mysql
Sql :: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Sql :: mysql select greater than yesterday
Sql :: mysql drop primary key
Sql :: Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Sql :: ORACLE RIGHT TWO DIGITS
Sql :: sql delete last row
Sql :: postgresql create table with index
Sql :: set username and password for postgresql database
Sql :: mysql strict_trans_tables
Sql :: autocommit mysql
Sql :: fill a column in database with a value
Sql :: check message id sql server
Sql :: insert all or first in oracle sql
Sql :: sql query to copy data from one column to another
Sql :: add primary key to existing table sql
Sql :: mysql column start with string
Sql :: postgresql make each element in array distinct
Sql :: select * from table where name like
Sql :: oracle current timestamp insert statement
Sql :: insert into table from another table mysql
Sql :: sql update from select
Sql :: firebase bigquery cloud message
Sql :: reset sql auto increment
Sql :: Uncaught Error: Call to undefined function DatabaseOldmysqli_connect()
Sql :: create column sql
Sql :: mysql update set sum
Sql :: sql server date now

Search

SQL

find column name in database

ADD CONTENT