2,187
edits
Difference between revisions of "MS SQL"
Jump to navigation
Jump to search
Added "Commands"
(Initial creation - Added maintenance tasks) |
(Added "Commands") |
||
| Line 29: | Line 29: | ||
#* File extension: <code>trn</code> | #* File extension: <code>trn</code> | ||
#* File age: Select as appropriate | #* File age: Select as appropriate | ||
== Commands == | |||
Crib sheet of some very basic stuff | |||
<source lang="sql"> | |||
SELECT * FROM MASTER..SYSDATABASE /* Show databases */ | |||
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) */ | |||
</source> | |||