To get the details of the table structure along with the indexes and the constraints , you can use the sp_help command as demonstrated in this blog post.
How to get the table structure in SQL Server ?
Use AdventureWorks2014 GO sp_help 'HumanResources.Employee'
