2,187
edits
Difference between revisions of "MS SQL"
Jump to navigation
Jump to search
m
→Commands: Minor update
m (Added Microsoft category) |
m (→Commands: Minor update) |
||
| Line 97: | Line 97: | ||
<source lang="sql"> | <source lang="sql"> | ||
SELECT * FROM MASTER.. | SELECT * FROM MASTER..SYSDATABASES /* Show databases */ | ||
EXEC sp_databases; /* Show databases */ | |||
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%' /* Show tables */ | SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%' /* Show tables */ | ||
SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' /* Show base tables only (not views etc) */ | SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' /* Show base tables only (not views etc) */ | ||