Table information 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 vote139 views3 answers
Find below average salary in sql
SQL
3 votes155 views1 answer
Force using index oracle
SQL
0 vote135 views1 answer
Group by two columns postgres
SQL
0 vote132 views1 answer
Alasql delete column
SQL
0 vote121 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote149 views1 answer
Postgresql inheritance
SQL
0 vote236 views1 answer
How to get all values in a table mysql in c#
SQL
3 votes139 views1 answer
Postgres select max value
SQL
0 vote129 views1 answer
Pgsql is not permitted to log in
SQL
0 vote129 views1 answer
Python sqlalchemy orm to select null values
SQL