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 |
|
rajusvs
Starting Member
9 Posts |
 Posted - 2001-12-03 : 12:01:43
|
| Can we export sysobjects/syscolumns tables to another database. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-03 : 12:25:50
|
| Every database should contain a sysobjects and syscolumns table. If you are wanting to recreate a database schema into a new database, then I would suggest you go into Enterprise Manager, right-click on your Database, and choose All Tasks, Generate SQL Scripts. Then open a Query Analyzer window and execute that generated script in the new database.-------------------It's a SQL thing... |
 |
|
|
rajusvs
Starting Member
9 Posts |
Posted - 2001-12-03 : 15:24:54
|
| I want to transfer the data of sysobjects and syscolumns tables data of one databases to another database with diff names of the tables. when i try to do this with export option, i could not able to see the table in the transformation, i tried the there option, try to write the data into file and upload into the tables, even i could not able to do this for sysobjects. Please suggest me how can I transfer the data of these tables to another database. |
|
|
|
shankarc
Starting Member
37 Posts |
Posted - 2001-12-03 : 15:30:04
|
| Have you tried this withe the Select InTo Statement.Select *into DestinationDatabase..TablenameFrom SourceDatabase..sysobjects |
|
|
|
|
|
|
export sysobjects/syscolumns