Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql query to return field name of a table

select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS 
where TABLE_NAME = 'tablename'
Comment

PREVIOUS NEXT
Code Example
Sql :: SQL Server run query on linked server 
Sql :: sql date with month and year only 
Sql :: nested select sql 
Sql :: sql check if table exists 
Sql :: postgres get last value 
Sql :: if else sql 
Sql :: sql server python connection 
Sql :: sql as 
Sql :: mysql generate create table script 
Sql :: delete record mysql 
Sql :: mysql query to select the highest value 
Sql :: create a table in sql 
Sql :: UNION ALL LEFT JOIN 
Sql :: changing column names in sql query results 
Sql :: mysql sublime build system 
Sql :: oracle last connection 
Sql :: get last record deluge 
Sql :: switch users mysql 
Sql :: get comma separated values in mysql with group by 
Sql :: sql order 
Sql :: mysql update from n to 100 
Sql :: sql track modification 
Sql :: sql primary key 
Sql :: how to connect sqlalchemy to mysql and deploy it 
Sql :: sql length 
Sql :: sql create database statement 
Sql :: sql min 
Sql :: sql convert int to string 
Sql :: sqlite3 python foreign key 
Sql :: Remove duplicate old value in mysql 
ADD CONTENT
Topic
Content
Source link
Name
6+2 =