Sql

Search

select table column name in sql

/**
You must have all privillage to access this, else it will denaid access :)
**/

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'tableName';

Comment

SQL column name

SELECT table_name, column_name, data_type, data_length
FROM USER_TAB_COLUMNS
WHERE table_name = 'MYTABLE'

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql right join
Sql :: SQL Syntax of LEFT JOIN
Sql :: sql power function
Sql :: postgresql conectar
Sql :: sql create tabel with primary key auto_increment code
Sql :: python mysql create table if not exists
Sql :: postgres describe table
Sql :: count the table indatabase
Sql :: SQL LIMIT With OFFSET Clause
Sql :: add clumn to table postgres
Sql :: sql last time database was accessed
Sql :: SQL Rename Column in a Table
Sql :: database stuck on restoring
Sql :: select only the month-day from date in PL-SQL
Sql :: like in postgresql
Sql :: SQL print multiple variable
Sql :: postgresql remove duplicate rows 2 columns
Sql :: sql restore database from backup
Sql :: SQL COUNT() with GROUP BY
Sql :: oracle gather table statistics
Sql :: SQL add a totals of differemt rows of the same id
Sql :: sql where not like in list
Sql :: datagrip execute procedure
Sql :: delete vs truncate sql server
Sql :: postgresql port 5432 not open
Sql :: tsql edit table column
Sql :: mysql delete older duplicates
Sql :: between date in sql server
Sql :: postgresql delete cascade
Sql :: mysql string split to array

Search

SQL

select table column name in sql

SQL column name

ADD CONTENT