Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spirit1
Cybernetic Yak Master
11752 Posts |
 Posted - 2004-06-28 : 09:51:29
|
| hi!when i do this in query analyzerexec sp_tables @TABLE_TYPE="'TABLE'"i get all of user table (of course :)) plus one system table "dtproperties" which owner is dbo and type is system.anyone knows why and how to get rid of it?Go with the flow & have fun! Else fight the flow :) |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-06-28 : 09:58:36
|
| [code]select * from information_schema.tableswhere table_type='BASE TABLE'and TABLE_NAME <> 'dtproperties'[/code] |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-06-28 : 10:14:03
|
| thanx man...Go with the flow & have fun! Else fight the flow :) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-28 : 11:01:07
|
| dtproperties is created by some Microsoft debugging utilities (Visual Database Tools / Visual Studio, that type of stuff), which also adds a stack of SPRocs called "dt_..."Kristen |
|
|
|
|
|
|
sp_tables question