Microsoft SQL Server is a relational database management system developed by Microsoft.
Parameter | Required | Description |
---|---|---|
Name | Yes | A unique identifier for your SQL Server source |
Host | Yes | The hostname or IP address of your SQL Server instance |
Port | Yes | The port number on which SQL Server is running (default: 1433) |
Database Name | Yes | The name of the database you want to connect to |
Schema Name | No | Optional schema name (default schema is ‘dbo’) |
User | Yes | Username with appropriate permissions to access the database |
Password | Yes | Password for the specified user |
SELECT
- For reading data from tables and viewsVIEW DEFINITION
- For accessing object metadataVIEW DATABASE STATE
- For viewing database state informationCONNECT
- For connecting to the database