If you want to use the command line (cli) ms sql query tool you need those files:
1 2 3 4 | 95’744 ATL80.dll 119’000 batchparser90.dll 140’504 SQLCMD.EXE 24’792 SQLCMD.rll |
Set the tablelength to max 20 chars:
1 | set SQLCMDMAXFIXEDTYPEWIDTH=20 |
More settings can be found here
Connect to the SQL Server:
1 | c:tmpsqlcmd>sqlcmd –SserverName1> use DATABASE2> goChanged database context to ‘database’. |
Show all tables of the selected database:
1 | 1> SELECT * FROM INFORMATION_SCHEMA.TABLES2> WHERE TABLE_TYPE = ‘BASE TABLE’3> go |
