Table infromation in sql server

SELECT
  	TABLE_NAME
FROM
  	INFORMATION_SCHEMA.TABLES
/******************************************************/
EXEC sp_help dbo.mytable;
/******************************************************/
EXEC sp_columns dbo.mytable;

Source: chartio.com

Similar codes

0 vote211 views1 answer
How to find unique key in sql
SQL
0 vote220 views2 answers
Sqlite unix timestamp
SQL
13 votes200 views3 answers
Uninstall mysql centos 7
SQL
1 vote216 views1 answer
Pv mysql import
SQL
1 vote216 views1 answer
Select if then postgresql
SQL
6 votes226 views2 answers
How to copy data in sql
SQL
0 vote207 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
2 votes219 views3 answers
How to pass password mysql command line
SQL
1 vote219 views2 answers
Drop table if exists test
SQL
0 vote208 views1 answer
Show all mongodb
SQL