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

1 vote297 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote296 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote295 views1 answer
Mysql aspas simples
SQL
0 vote275 views1 answer
Add column to table with default value plsql
SQL
0 vote297 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote257 views1 answer
Sqlite3 now
SQL
0 vote296 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
3 votes286 views1 answer
Define REGEXP?
SQL
0 vote301 views1 answer
Sql server information_schema temp tables
SQL
0 vote294 views1 answer
Mysql set variable to today's date
SQL