SQL: Exec sp_tables
| query |
| |
REMARKS |
TABLE_NAME |
TABLE_OWNER |
TABLE_QUALIFIER |
TABLE_TYPE |
| 1 |
[empty string] |
syscolumns |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 2 |
[empty string] |
syscomments |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 3 |
[empty string] |
sysdepends |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 4 |
[empty string] |
sysfilegroups |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 5 |
[empty string] |
sysfiles |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 6 |
[empty string] |
sysfiles1 |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 7 |
[empty string] |
sysforeignkeys |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 8 |
[empty string] |
sysfulltextcatalogs |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 9 |
[empty string] |
sysfulltextnotify |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 10 |
[empty string] |
sysindexes |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 11 |
[empty string] |
sysindexkeys |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 12 |
[empty string] |
sysmembers |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 13 |
[empty string] |
sysobjects |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 14 |
[empty string] |
syspermissions |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 15 |
[empty string] |
sysproperties |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 16 |
[empty string] |
sysprotects |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 17 |
[empty string] |
sysreferences |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 18 |
[empty string] |
systypes |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 19 |
[empty string] |
sysusers |
dbo |
silverwareconsultingdb |
SYSTEM TABLE |
| 20 |
[empty string] |
dtproperties |
dbo |
silverwareconsultingdb |
TABLE |
| 21 |
[empty string] |
User |
dbo |
silverwareconsultingdb |
TABLE |
| 22 |
[empty string] |
User2 |
dbo |
silverwareconsultingdb |
TABLE |
| 23 |
[empty string] |
UserType |
dbo |
silverwareconsultingdb |
TABLE |
| 24 |
[empty string] |
Widget |
dbo |
silverwareconsultingdb |
TABLE |
| 25 |
[empty string] |
sysconstraints |
dbo |
silverwareconsultingdb |
VIEW |
| 26 |
[empty string] |
syssegments |
dbo |
silverwareconsultingdb |
VIEW |
| 27 |
[empty string] |
vwUser |
dbo |
silverwareconsultingdb |
VIEW |