/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

1 vote337 views1 answer
Is sql fast
SQL
2 votes309 views1 answer
Oracle cpu per session
SQL
0 vote330 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote291 views1 answer
Sqlite3 now
SQL
0 vote345 views1 answer
Influxdb clone measurement
SQL
0 vote325 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote350 views2 answers
Get item by composite primary key mysql
SQL
0 vote314 views1 answer
Optimize sql query
SQL
0 vote338 views1 answer
Mysql search like but first exact match
SQL
0 vote303 views1 answer
Procedures and functions in pl/sql
SQL