Sql

Search

sql search all tables for attributes

SELECT
  sys.columns.name AS ColumnName,
  tables.name AS TableName
FROM
  sys.columns
JOIN sys.tables ON
  sys.columns.object_id = tables.object_id
WHERE
  sys.columns.name = 'ColumnName'

Comment

PREVIOUS	NEXT

Code Example
Sql :: create a PostgreSQL user django on mac
Sql :: update table sql multiple set
Sql :: increment id in mysql
Sql :: sql join
Sql :: postgresql could not start server mac
Sql :: update sql sintax
Sql :: express mysql
Sql :: call function in query sql server
Sql :: sqlite get date only
Sql :: insert into sql
Sql :: union all query in sql
Sql :: delete table in mysql
Sql :: 2nd highest value in sql
Sql :: copy column from one table to another without column duplicate postgres
Sql :: setval in postgres
Sql :: psql show db
Sql :: sql like case sensitive
Sql :: mssql describe stored procedure sqlcmd
Sql :: multiple left join mysql
Sql :: distinct in sql
Sql :: mssql remove duplicate rows
Sql :: timestamp datatype in sql
Sql :: convert negative to positive in sql
Sql :: mysql query where in select
Sql :: trigger sql
Sql :: create postgres role and database for bitbucket
Sql :: date datatype in livesql
Sql :: mssql coalesce
Sql :: MySql Subtract a table from another
Sql :: rename temp table column name in sql server

Search

SQL

sql search all tables for attributes

ADD CONTENT