Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from your_database_name.sys.tables
- use a;
- go
- select * from sys.tables; -- selects table info from a
- select * from b.sys.tables; -- selects table info from b
- select * from your_database_name.information_schema.tables
Add Comment
Please, Sign In to add comment