How to find the SharePoint Site Template being used?

How to find the site template of an existing SharePoint site? There are many ways to find the site definition being used for a site, Here are some:

1. Use SharePoint Manager to find the SharePoint site template. Navigate through the site, and look for “Web Template” as in the below picture.

2. Stsadm: Get current site template in SharePoint
stsadm.exe -o enumallwebs -databasename <content-db-name> > Template.txt
Now, Open the template.txt file and check for template. This trick can be used to find site template name for SharePoint 2010 even.

3. Sql Server: SQL Server is the back-bone of SharePoint, So lets use the SQL Query to determine SharePoint site template used:
SELECT Title, WebTemplate FROM dbo.Webs WHERE Title=‘Your Site’

4. You can programmatically use SharePoint Object Model to find site template of SharePoint site. Just query  SPWeb.WebTemplateId. Here is the reference table for SharePoint 2007:

5. Find template used to Create Site using PowerShell:
To get SharePoint site template id using PowerShell: 

$web = Get-SPWeb "https://sharepoint.crescent.com"
Write-Host $web.WebTemplate "#" $web.WebTemplateId 

You can get the list of site templates by using a PowerShell Cmd-let: Get-SPWebTemplate

Here is the reference table for SharePoint 2010:

6. Last but not least:
Go to the view source of the SharePoint page >> Search for “SiteTemplateID” to find site template name SharePoint 2010.