Mssql

From Halfface
Revision as of 22:26, 16 September 2014 by Ekaanbj (talk | contribs)
Jump to navigation Jump to search

Connect to database.

# tsql -S 131.115.162.11 -U hpsc -P '=_9xe=paP2F*e2hu' -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