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

Search
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';
source
similar questions
find table from column name in sqlwrite a query to display the column name and data type of the table employee get column name sql serverget all columns from table sqlget table column names sql ssmssql server search column name in all tablesget columns number sqlserver name sql serverfind column name in databasemssql get all table nameshow to check data type in sql serverhow to view column names of a table in sqlsql server find columns list in tablesget all tables with column name sqlsearch for column name in sql db when i don 27t know which table it is inget the db column names from a sqldatareaderhow to find sql server nameread all columns of a table sqlhow to get all table names in sql queryview column data type sqlchecking data type in sql serversql server find 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