Breaking News: Grepper is joining You.com. Read the official announcement!

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

Lazy Lemur answered on January 29, 2021 Popularity 9/10 Helpfulness 10/10

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

related get column types SQL SERVER

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

Comment

SELECT COLUMN_NAME, 
	DATA_TYPE, 
    IS_NULLABLE, 
    CHARACTER_MAXIMUM_LENGTH, 
    NUMERIC_PRECISION, 
    NUMERIC_SCALE 
FROM 'your_database_name'.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='your_table_name';

Popularity 9/10 Helpfulness 10/10 Language sql

Source: www.google.com

Tags: get names sql sql-server types

Link to this answer
Share Copy Link

Contributed on Jan 29 2021

Lazy Lemur

0 Answers Avg Quality 2/10

Closely Related Answers

get column types SQL SERVER

Comment

SELECT DATA_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE 
     TABLE_SCHEMA = 'yourSchemaName' AND
     TABLE_NAME   = 'yourTableName' AND 
     COLUMN_NAME  = 'yourColumnName'

Popularity 9/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: column-types column-typ

Link to this answer
Share Copy Link