Skip to content
/ PRS Public

A simple command-line tool to query database schema in Microsoft SQL Server

Notifications You must be signed in to change notification settings

wooly905/PRS

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

prs NuGet latest version MIT license

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.

pic1 pic2 pic3

How to use this tool:

pic4

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.

pic5

Show connection string (prs scs)

pic6

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.

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]

About

A simple command-line tool to query database schema in Microsoft SQL Server

Topics

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages