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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Table Script

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-24 : 01:25:37
seema writes "Dear Sir
I want to create table script programmaticaly as we are getting through 'enterprise manager'. Is there any System SP for table script genaration ?, like I am genarating SP script through sp_helptext.
thanx"

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2002-06-24 : 07:17:09
Look up the SQL-DMO Script Method in BOL....

Peace

Rick

Go to Top of Page

MakeYourDaddyProud

184 Posts

Posted - 2002-06-24 : 08:15:24
Your plight seems to be a bit convoluted, I was expecting more info, however DMO or jus' plain ol' CREATE TABLE... should do the trick.

Note that it is a bit more work with DMO and requires a programmable client i.e. VB...

Dan

Go to Top of Page
   

- Advertisement -