Timeline for SQL Server 2012 - where is the table in dbo? [closed]
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 1, 2014 at 20:51 | history | closed |
Mark Storey-Smith RolandoMySQLDBA Michael - sqlbot Kin Shah Hannah Vernon♦ |
Not suitable for this site | |
| Jan 1, 2014 at 19:35 | answer | added | Troy | timeline score: 1 | |
| Jan 1, 2014 at 3:18 | answer | added | Kin Shah | timeline score: 0 | |
| Dec 31, 2013 at 22:35 | comment | added | user2061466 | Hello Kin, I used your query syntax to check the location for Documents table. It is indeed created in database TSQL2012. I appreciate your help! | |
| Dec 31, 2013 at 21:32 | answer | added | Katherine Villyard | timeline score: 0 | |
| Dec 31, 2013 at 12:21 | review | Close votes | |||
| Jan 1, 2014 at 20:51 | |||||
| Dec 31, 2013 at 4:48 | comment | added | Kin Shah |
You will find the table under the database where you did the select * from … Or possibly, you might have created it under different schema … SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']' AS SchemaTable FROM sys.tables where name = 'documents' This will give you schema and table name.
|
|
| Dec 31, 2013 at 4:47 | comment | added | user2061466 | Hello Kin, I used select * from dbo.Documents, the data being inserted are displayed, but I can't find the table under either master or the TSQL2012 database. I checked 'Table' folder under TSQL2012. Under the master db, there was no 'Tables' folder. I see temporarydb folder. Please advise me where the table is created. Thanks! | |
| Dec 31, 2013 at 4:39 | comment | added | Kin Shah |
Then just do a select * from Dcouments to see if the data is there or not.
|
|
| Dec 31, 2013 at 4:37 | comment | added | user2061466 | Hello Kin, Thanks for the reply. I create the table using TSQL2012 database (I created it for exercise purpose), Then I create the table Documents. I run the query suggested by you, it return Documents under the name column. Thanks! | |
| Dec 31, 2013 at 3:52 | comment | added | Kin Shah |
insert into .. select will copy data to an existing table. Is the table dbo.Documents created ? Also what does select name from sys objects where name = 'Documents' and type = 'U' gives ? The table name should be there else it is created in wrong database or it is not created at all.
|
|
| Dec 31, 2013 at 3:45 | answer | added | Thomas Stringer | timeline score: 1 | |
| Dec 31, 2013 at 3:39 | history | edited | user2061466 | CC BY-SA 3.0 |
added 11 characters in body
|
| Dec 31, 2013 at 3:19 | history | asked | user2061466 | CC BY-SA 3.0 |