wooly905.prs 1.0.1.2

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet tool install --global wooly905.prs --version 1.0.1.2
This package contains a .NET tool you can call from the shell/command line. 
dotnet new tool-manifest # if you are setting up this repo
dotnet tool install --local wooly905.prs --version 1.0.1.2
This package contains a .NET tool you can call from the shell/command line. 
#tool dotnet:?package=wooly905.prs&version=1.0.1.2                

                    
                

            
nuke :add-package wooly905.prs --version 1.0.1.2

PRS

A table schema query tool of Microsoft SQL Server

source code - https://github.com/wooly905/PRS

Introduction:

The following is the tables created by Hangfire.

pic1 pic2 pic3

The screenshot above shows the tables created by Hangfire. It shows all tables in the Hangfire database and columns of Hangfire.Job and HangFire.State tables.

How to use this tool:

pic4

Setup connection string (prs wcs)

pic5

Show connection string (prs scs)

pic6

Dump schema to local machine (prs dds)

pic7

Find table (prs ft) - table name can be partial

pic8

Find column (prs fc) - find matched column in all tables

pic9

Find column in table(s) (prs ftc)

pic10

Display all columns of a table

image

Find stored procedure

prs fsp [full or partial name of a storec procedure to find]

Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

Version Downloads Last updated
7.0.0 186 5/8/2023
1.0.1.2 200 3/31/2023