lee-pai-long
1/20/2016 - 2:24 PM

list-all-tables-in-db_sqlserver.md

[SQLSERVER] List all tables in database

Connect to server

> osql -S SERVER/INSTANCE -E

(-E allow to connect without password)

Select DATABASE

> use DATABASE

List tables in database

> SELECT * FROM sysobjects WHERE xtype = 'u'