Saturday, July 18, 2009

Show databases and tables in MSSQL

  • MySQL use show databases and show tables
  • so MSSQL use ?
Select [Name] From Master..Sysdatabases
select name from ..sysobjects where xtype = 'U';

or

select name from sys.databases
use database
select name from sys.tables
อ้างอิง

No comments:

Post a Comment