Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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 
ADD CONTENT
Topic
Content
Source link
Name
3+1 =