/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

7 votes301 views1 answer
Safe update mysql
SQL
0 vote321 views1 answer
Python list from sql
SQL
10 votes300 views6 answers
Between sql
SQL
1 vote334 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
22 votes338 views3 answers
How to join three tables in sql using joins
SQL
11 votes311 views3 answers
Change column name sql server management studio
SQL
4 votes305 views3 answers
Drop Table Oracle
SQL
0 vote380 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote327 views1 answer
Psql store procedure-return multiple table values
SQL
14 votes383 views1 answer
How to export db from mysql
SQL