/SQL/TSQL GET ALL COLUMNS IN TABLE

TSQL GET ALL COLUMNS IN TABLE

TSQL GET ALL COLUMNS IN TABLE

/*Get all columns from a table (sql server)*/
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'table name';

1

Get all columns from table sql

SELECT
  	TABLE_NAME
FROM
  	INFORMATION_SCHEMA.TABLES

1

Source: chartio.com

Similar codes

0 vote343 views1 answer
Kill slow queries mysql
SQL
0 vote308 views1 answer
Stop psql server windows
SQL
0 vote340 views1 answer
T sql dynamic top n query
SQL
1 vote327 views1 answer
Mariadb case switch
SQL
0 vote356 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote304 views1 answer
Mysql column start with string
SQL
2 votes335 views1 answer
Removing view
SQL
24 votes334 views4 answers
Mysql datetime
SQL
0 vote316 views1 answer
Como hacer un select entre fechas mysql
SQL
1 vote310 views1 answer
Sql select table header
SQL

Share