/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 vote143 views1 answer
How to create a table based on another table in mysql
SQL
0 vote90 views1 answer
Postgresql subquery
SQL
-2 votes224 views1 answer
How-to-remove-mysql-root-password
SQL
5 votes138 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
-2 votes130 views3 answers
Oracle tablespace usage
SQL
4 votes134 views4 answers
Sqlite describe table
SQL
0 vote134 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote133 views1 answer
Alter table myisam to innodb
SQL
0 vote145 views2 answers
Uninstall postgresql mac
SQL
0 vote135 views1 answer
How to add boolean column in postgresql
SQL