[NFBCS] SQL Server Management Studio and large amounts of data

[Tracy Carcione]

I usually know roughly what table I’m after, but I have paged down through long lists before, looking at what’s there.

Also, SQL has a name sysobjects, and another syscolumns, and you can use those to write a query to see what’s around.  Don’t select all columns from all tables, though!

I found this query to get some column names from a particular table, which perhaps you can modify:

 

Select a.name as table_name

,b.name as col_name

>From sysobjects a,

Syscolumns b

Where a.ID = b.ID

And b.name like ‘%depar%’

 

I like to set SQL output to a file when I’m testing or looking at something.  For me, it’s much easier to look at a file than to try to look at the grid in SQL.

HTH.

Tracy

 

 

 

From: NFBCS [mailto:nfbcs-bounces at nfbnet.org] On Behalf Of Walker, Michael E. (UMSL-Student) via NFBCS
Sent: Monday, November 23, 2020 2:16 AM
To: NFBCS at nfbnet.org
Cc: Walker, Michael E. (UMSL-Student)
Subject: [NFBCS] SQL Server Management Studio and large amounts of data

 

Hi,

 

If you are using a screen reader, how do you most efficiently navigate large amounts of data? Suppose your database has over six hundred tables. One cannot use first letter navigation easily, since many table names begin with DBO. I might be browsing through the long list of tables, to get an idea of what the table name is, to write a query.

 

Thank you,

Mike