Sql

Search

sql server query field names

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       UPPER(c.name) LIKE '%colname%'
ORDER BY    TableName
            ,ColumnName;

Comment

PREVIOUS	NEXT

Code Example
Sql :: for row in sql database python loop
Sql :: get create sql of hibernqte entity
Sql :: compute age mysql
Sql :: trigger stock phpmyadmin output message
Sql :: como hacer una consulta en sql
Sql :: select into a new table mysql
Sql :: plsql function that return a table
Sql :: count record in same name condition
Sql :: conectar base de datos mysql con java
Sql :: SQL FULL OUTER JOIN With AS Alias
Sql :: redshift alter table alter column set not null
Sql :: Insert into ... values ( SELECT ... FROM ... )
Sql :: Every Derived yable must have its own alias
Sql :: tsql For XML Path('), TYPE).value
Sql :: MySQL Quartiles in SQL query
Sql :: sql query use select name inside where clause
Sql :: extract domain name from email id mariadb
Sql :: limiting query result using where in sql
Sql :: call object contructor and call methods of object
Sql :: classement rang mysql 7
Sql :: fix sqlite3 ruby on rails
Sql :: sql create table with references not primary key
Sql :: how to fix mysql stop unexpectedly
Sql :: sqlite closes value
Sql :: difference between nvl and nvl2 in oracle
Sql :: Table aliases
Sql :: sql query for login with email or username
Sql :: MSSQL MAX VALOR
Sql :: opensuse stop MySQL
Sql :: Use Join On DataTables \| Join Two Tables With ssp.class.php (Select & Search)

Search

SQL

sql server query field names

ADD CONTENT