Tuesday, April 11, 2017

use the ghetto, not quite SSMS in Visual Studio 2017!

at: Tools > SQL Server > New Query... ...you'll end up getting a dialog box where you'll punch in server specs. You'll end up with an interface that is a blank white window with a dropdown up top for picking a particular database at the server. Pick a database and then start punching in queries in the white space. Use the green rightward pointing arrow to run the queries. See what tables are available like so:

SELECT * FROM INFORMATION_SCHEMA.TABLES

No comments:

Post a Comment