sql query to get column names and data types in sql server

Solutions on MaxInterview for sql query to get column names and data types in sql server by the best coders in the world

showing results for - "sql query to get column names and data types in sql server"
Valeria
07 Nov 2018
1SELECT COLUMN_NAME, 
2	DATA_TYPE, 
3    IS_NULLABLE, 
4    CHARACTER_MAXIMUM_LENGTH, 
5    NUMERIC_PRECISION, 
6    NUMERIC_SCALE 
7FROM 'your_database_name'.INFORMATION_SCHEMA.COLUMNS
8WHERE TABLE_NAME='your_table_name';
queries leading to this page
sql server see column typehow get get column specs sqlsql query to get column data type in sqlmssql get column names and typessql server get all column names datatype in a tabledisplay the type of columns in ms sqlsql server see column data typeget column names and types sqlsql column name typesql query to get column names from table in sql serverget column types sql serversql query to get column names and data types in sql serversql server column names with numbershow to get all column with datatype names in sql serverget column names from type sqlsql get columns and data typeslist columns and data types sql querysql get column names and datatypes from tablelist column names with datatype in sqlms sql server query column namessql server get table columns and typesget column names and datatypes from table sqlsql server check data type of columnmssql get column typessql server get column typessql query to get column data type in sql serverget datatype of columns in sql server in databasesql get column names and data typesget column name with datatype in sql serversql server query for table column names and typesget column type sql serverlist column names with datatypes in sqlsql server get column data typehow to get column types in sqlsql query to get column name and data type from table in sql serverget column names from types sqlsql query to get column data type from table in sql serversql get columns with typeshow to get table and column names with data type in sql serverhow to get table and column names in sql serversql query to get column names and data types in sql server