SP_HELP in SQL Server

USE BGDB;
GO
EXEC SP_HELP
GO

It will display all objects of BGDB database.

We can get individual object details as below.

USE BGDB;
GO
EXEC SP_HELP 'dbo.CustomerProducts'
GO

That’s It.
Enjoy Learning.