Mssql

From Halfface
Revision as of 22:23, 16 September 2014 by Ekaanbj (talk | contribs) (Created page with '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 tabl…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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)