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 |