wooly905.prs
7.0.0
dotnet tool install --global wooly905.prs --version 7.0.0
dotnet new tool-manifest # if you are setting up this repo dotnet tool install --local wooly905.prs --version 7.0.0
#tool dotnet:?package=wooly905.prs&version=7.0.0
nuke :add-package wooly905.prs --version 7.0.0
PRS
A simple command-line tool to query database schema in Microsoft SQL Server
Introduction:
This is a tool to help you quickly search the names of objects (columns, tables, stored procedure) in Microsoft SQL server. This tool has been released as a dotnet global tool. You can install it by the following dotnet command,
dotnet tool install wooly905.prs -g
The followings are the examples to show you how to use this tool.
The following screenshots show you the tables and columns created by Hangfire.
How to use this tool:
Setup connection string (prs wcs)
This is the first thing to do for this tool. Make sure your connection string is good with correct host URL, database name, username, and password.
Show connection string (prs scs)
Dump schema to local machine (prs dds)
This is the command to dump the database schema into your local user folder. This command must be executed for any query command below.
Find table (prs ft) - table name can be partial
Find column (prs fc) - find matched column in all tables
Find column in table(s) (prs ftc)
Display all columns of a table
Find stored procedure
prs fsp [full or partial name of a storec procedure to find]
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net7.0 is compatible. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
This package has no dependencies.