/SQL/Sql query to get column names and data types in sql server

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

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';

Source: google.com

Similar codes

0 vote205 views1 answer
Oracle list dblink
SQL
38 votes250 views6 answers
Ubuntu install mysql client
SQL
0 vote219 views1 answer
Except in sql
SQL
1 vote245 views1 answer
Oracle columns table
SQL
0 vote182 views1 answer
Big query add table rows to another table
SQL
2 votes210 views1 answer
Sql server check for value in multiple columns
SQL
0 vote179 views1 answer
How to check oracle index table
SQL
4 votes217 views2 answers
Sql table
SQL
12 votes242 views4 answers
How to check mysql version ubuntu
SQL
0 vote222 views1 answer
Get who is hired in month in sql
SQL