/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

3 votes316 views2 answers
Mysql time
SQL
13 votes310 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
9 votes369 views4 answers
Mysql set id auto increment
SQL
21 votes333 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
2 votes369 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote345 views1 answer
Postgres type equivalent to timespan c#
SQL
1 vote290 views1 answer
Postgres grant read only access to database
SQL
0 vote358 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote328 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote318 views1 answer
Remove from table where
SQL