Connect to SQL Server from command prompt – list tables and database
Q. How do I connect to Microsoft SQL Server from command prompt? I just wanted to see list of tables and database. A. MS- SQL Server is relational database management system. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) used by both Microsoft and Sybase. There is command line tool available and it is called as sqlcmd. you need to enter the word GO after every command. On the Start menu click Run. In the Open box type cmd, and then click OK to open a Command Prompt...