SQL column name

Get column name sql server

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Customers'

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';

SQL column name

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

Source: stackoverflow.com

Similar codes

1 vote316 views1 answer
Mysql copy table1 to table2
SQL
0 vote309 views1 answer
Sql select min row
SQL
0 vote314 views1 answer
Oracle sql drop table
SQL
0 vote303 views1 answer
Mod function example
SQL
-1 vote345 views3 answers
PS5
SQL
0 vote316 views1 answer
How to drop a trigger in postgresql
SQL
0 vote353 views1 answer
Apt install sql server
SQL
23 votes336 views6 answers
How to create table in sql
SQL
0 vote298 views1 answer
Drop all procedures sql server
SQL
1 vote314 views1 answer
Oracle sql listagg
SQL