SQL :Important Queries

SQL Server : Important Queries

1.To display all tables in a database

SELECT * FROM information_schema.tables

2. To display table information

 sp_help table_name