To get the cmdlets and functions that come with SQL Server-related modules, you can use the following command:
Get-Command –Module *SQL*
The following table lists the cmdlets included in the SQLPS module in a typical SQL Server 2014 installation. You can use this as a reference when you are looking up SQL Server cmdlets. You will notice that there are two SQL Server modules: SQLPS and SQLASCMDLETS. SQLPS contains mostly database engine cmdlets, while the SQLASCMDLETS module contains cmdlets related to SQL Server Analysis Services.
Module name |
Command type |
Name |
---|---|---|
SQLPS |
Function |
|
SQLASCMDLETS |
Cmdlet |
|
SQLPS |
Cmdlet |
|
SQLPS |
Cmdlet |
|
SQLPS |
Cmdlet |
|
SQLASCMDLETS |
Cmdlet |
|
SQLPS |
Cmdlet |
|
SQLPS |
Cmdlet |
|
SQLPS |
Cmdlet |
|
SQLPS |
Cmdlet |
|
SQLPS |
Cmdlet |
|