Connect to database.
# tsql -S 192.168.0.1 -U user -P password -p 1433
locale is "en_US.utf-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Show tables.
1> SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'
2> go
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
master dbo spt_fallback_db BASE TABLE
master dbo spt_fallback_dev BASE TABLE
master dbo spt_fallback_usg BASE TABLE
master dbo spt_monitor BASE TABLE
master dbo spt_values BASE TABLE
(5 rows affected)
show databases
1> SELECT name FROM master..sysdatabases
2> go
name
master
which version of mssql
1> select @@microsoftversion/0x01000000 as version
2> go