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

6 votes126 views3 answers
Mysql remove user privileges
SQL
0 vote145 views1 answer
How to add auto increment primary key
SQL
0 vote134 views1 answer
Cartesian product sql
SQL
0 vote150 views1 answer
Get last inserted primary key
SQL
2 votes119 views1 answer
Sql server current date minus 5 years
SQL
0 vote109 views1 answer
Sql create table with datetime automatically
SQL
0 vote113 views1 answer
Mysqldump ignore table
SQL
2 votes142 views2 answers
Calculate percentage in sql
SQL
0 vote257 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote116 views2 answers
Sqlite
SQL