How can I see all column names in SQL?

Question

USE db_name; DESCRIBE table_name; it'll give you column names with the type. 11 янв. 2016 г.

How do I get a list of all column names in SQL?

The following query will give the table's column names:1SELECT column_name FROM INFORMATION_SCHEMA. COLUMNS.2WHERE TABLE_NAME = 'News'Retrieving Column Names of a Table in SQL Server 2012 - C# Corner

How do I get all columns in SQL?

Little SQL Server Tricks: Get All Columns in Your Database1SELECT.2TABLE_SCHEMA,3TABLE_NAME,4COLUMN_NAME,5DATA_TYPE,6COLUMN_DEFAULT,7CHARACTER_MAXIMUM_LENGTH.8FROM INFORMATION_SCHEMA. COLUMNS.Little SQL Server Tricks: Get All Columns in Your Database

Expert · Answer

The following query will give the table's column names:1SELECT column_name FROM INFORMATION_SCHEMA. COLUMNS.2WHERE TABLE_NAME = 'News'Retrieving Column Names of a Table in SQL Server 2012 - C# Corner

Expert · Answer

Little SQL Server Tricks: Get All Columns in Your Database1SELECT.2TABLE_SCHEMA,3TABLE_NAME,4COLUMN_NAME,5DATA_TYPE,6COLUMN_DEFAULT,7CHARACTER_MAXIMUM_LENGTH.8FROM INFORMATION_SCHEMA. COLUMNS.Little SQL Server Tricks: Get All Columns in Your Database

How can I see all column names in SQL?

How do I get a list of all column names in SQL?

How do I get all columns in SQL?

Related Questions