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

4 votes250 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote240 views1 answer
Joomla execute raw sql
SQL
2 votes208 views1 answer
How to get weekday from old date in sql
SQL
2 votes209 views2 answers
Mysql add hours to time field
SQL
0 vote215 views1 answer
How to convert external table to managed table in hive
SQL
28 votes197 views4 answers
Delete database mysql
SQL
0 vote218 views1 answer
Update sqlite
SQL
0 vote205 views1 answer
C# execute transact sql
SQL
0 vote202 views1 answer
Mysql multiple primary keys
SQL
5 votes220 views1 answer
Oracle create table comment
SQL