Is there any sql query where my tables stored in the database should automatically

Is there any sql query where my tables stored in the database should
automatically come in xlsheet
*** Sent via Developersdex http://www.examnotes.net ***Hi Satish
You can check the following query
http://chanduas.blogspot.com/2005/0...n-database.html
this will list the tables in the database. You can save the result in
the excel sheet
please let me know if u have any questions
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---
*** Sent via Developersdex http://www.examnotes.net ***|||swata
You can write a simple VB program to declare SQL-DMO objects library and
script all objets to the file.
Dim oSS
Dim oDb
Dim oT
Set oSS = CreateObject("SQLDMO.SQLServer")
Set oDb = CreateObject("SQLDMO.Database")
Set oT = CreateObject("SQLDMO.Transfer")
oSS.Connect "SERVER", "User", "Pass"
Set oDb = oSS.Databases("pubs")
oT.CopyAllTables = True
oDb.ScriptTransfer oT,2,"C:\pubs.sql"
Set oT = Nothing
Set oDB = Nothing
Set oSS = Nothing
"swata sathish" <deepa_teenu@.yahoo.co.in> wrote in message
news:ufVn3t8pFHA.3664@.TK2MSFTNGP10.phx.gbl...
>
> Is there any sql query where my tables stored in the database should
> automatically come in xlsheet
> *** Sent via Developersdex http://www.examnotes.net ***