BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Table create script

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers)
View previous topic :: View next topic  
Author Message
Barak zabari
Guest





PostPosted: Tue Apr 12, 2005 12:47 am    Post subject: Table create script Reply with quote



D6 with MSSQL 2000
Is there a way to generate the table create script from delphi?

thanks
Barak



Back to top
Mike Shkolnik
Guest





PostPosted: Tue Apr 12, 2005 7:57 am    Post subject: Re: Table create script Reply with quote



Use my freeware TSMSQLGenerator component
http://www.scalabium.com/sqlscript.htm

You could generate the CREATE TABLE/INSERT/DELETE/UPDATE statements

--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com

"Barak zabari" <lotemlotad (AT) yahoo (DOT) com> wrote

Quote:
D6 with MSSQL 2000
Is there a way to generate the table create script from delphi?

thanks
Barak






Back to top
Mike Shkolnik
Guest





PostPosted: Tue Apr 12, 2005 9:45 am    Post subject: Re: Table create script Reply with quote



Sorry - I sent an incorrect link:
http://www.scalabium.com/download/smcmpnt.zip

There is the SQLGen.pas unit where is the required component

--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com

"Mike Shkolnik" <mshkolnik2002 (AT) ukr (DOT) net> wrote

Quote:
Use my freeware TSMSQLGenerator component
http://www.scalabium.com/sqlscript.htm

You could generate the CREATE TABLE/INSERT/DELETE/UPDATE statements

--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com

"Barak zabari" <lotemlotad (AT) yahoo (DOT) com> wrote in message
news:425b0c96 (AT) newsgroups (DOT) borland.com...
D6 with MSSQL 2000
Is there a way to generate the table create script from delphi?

thanks
Barak








Back to top
Mike Shkolnik
Guest





PostPosted: Tue Apr 12, 2005 9:46 am    Post subject: Re: Table create script Reply with quote

See my another post with correct link

--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com

"Barak zabari" <lotemlotad (AT) yahoo (DOT) com> wrote

Quote:
Thanks Mike but from what i see this component does not create a new
script
but process an existing one.
What i am looking for is something that will create a table script like
you
can get when you run the MSSQL Query analyzer.

For some reason i am pretty sure there is a way to do it an i just can't
remember what it is.


"Mike Shkolnik" <mshkolnik2002 (AT) ukr (DOT) net> wrote in message
news:425b7f5f (AT) newsgroups (DOT) borland.com...
Use my freeware TSMSQLGenerator component
http://www.scalabium.com/sqlscript.htm

You could generate the CREATE TABLE/INSERT/DELETE/UPDATE statements

--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com

"Barak zabari" <lotemlotad (AT) yahoo (DOT) com> wrote in message
news:425b0c96 (AT) newsgroups (DOT) borland.com...
D6 with MSSQL 2000
Is there a way to generate the table create script from delphi?

thanks
Barak










Back to top
Barak zabari
Guest





PostPosted: Tue Apr 12, 2005 10:31 am    Post subject: Re: Table create script Reply with quote

Thanks Mike but from what i see this component does not create a new script
but process an existing one.
What i am looking for is something that will create a table script like you
can get when you run the MSSQL Query analyzer.

For some reason i am pretty sure there is a way to do it an i just can't
remember what it is.


"Mike Shkolnik" <mshkolnik2002 (AT) ukr (DOT) net> wrote

Quote:
Use my freeware TSMSQLGenerator component
http://www.scalabium.com/sqlscript.htm

You could generate the CREATE TABLE/INSERT/DELETE/UPDATE statements

--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com

"Barak zabari" <lotemlotad (AT) yahoo (DOT) com> wrote in message
news:425b0c96 (AT) newsgroups (DOT) borland.com...
D6 with MSSQL 2000
Is there a way to generate the table create script from delphi?

thanks
Barak








Back to top
Barak zabari
Guest





PostPosted: Sat Apr 16, 2005 2:54 pm    Post subject: Re: Table create script Reply with quote

Thanks it helped alot.

"Mike Shkolnik" <mshkolnik2002 (AT) ukr (DOT) net> wrote

Quote:
Sorry - I sent an incorrect link:
http://www.scalabium.com/download/smcmpnt.zip

There is the SQLGen.pas unit where is the required component

--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com

"Mike Shkolnik" <mshkolnik2002 (AT) ukr (DOT) net> wrote in message
news:425b7f5f (AT) newsgroups (DOT) borland.com...
Use my freeware TSMSQLGenerator component
http://www.scalabium.com/sqlscript.htm

You could generate the CREATE TABLE/INSERT/DELETE/UPDATE statements

--
With best regards, Mike Shkolnik
EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
http://www.scalabium.com

"Barak zabari" <lotemlotad (AT) yahoo (DOT) com> wrote in message
news:425b0c96 (AT) newsgroups (DOT) borland.com...
D6 with MSSQL 2000
Is there a way to generate the table create script from delphi?

thanks
Barak










Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.