473,324 Members | 2,268 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

get create table script for a SQL Server object

Is there a function or something I can use to generate an sql script for an
object in an sql server. for example, I want to generate the CREATE TABLE
AS .... statement for a table. I don't want to use SMO or DMO but some kind
of .net functionality.
Sep 2 '06 #1
3 2794
Arch,

This is a SQL language problem, this newsgroup is about the VB.net language.
Even if you use a tool deditcated for for VB.Net.

By instance in the Managedment Tool for SQL server is this integrated,
however this is than more a question for the newsgroups ab out SQL
programming.

I hope this helps sofar,

Cor

"arch" <to********@yahoo.comschreef in bericht
news:11***************@angel.amnet.net.au...
Is there a function or something I can use to generate an sql script for
an object in an sql server. for example, I want to generate the CREATE
TABLE AS .... statement for a table. I don't want to use SMO or DMO but
some kind of .net functionality.

Sep 2 '06 #2
Perhaps I didn't make myself clear. I want to use VB.Net to generate the
SQL for an sql server table. Is this possible? There is no way this can be
done via Transact-SQL or any programming on the SQL Server (than I am aware
of). I was hoping there was some class library or something within the .Net
framework that could do this.

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:OF**************@TK2MSFTNGP05.phx.gbl...
Arch,

This is a SQL language problem, this newsgroup is about the VB.net
language. Even if you use a tool deditcated for for VB.Net.

By instance in the Managedment Tool for SQL server is this integrated,
however this is than more a question for the newsgroups ab out SQL
programming.

I hope this helps sofar,

Cor

"arch" <to********@yahoo.comschreef in bericht
news:11***************@angel.amnet.net.au...
>Is there a function or something I can use to generate an sql script for
an object in an sql server. for example, I want to generate the CREATE
TABLE AS .... statement for a table. I don't want to use SMO or DMO but
some kind of .net functionality.


Sep 2 '06 #3
arch,

There is at the moment not any class/method that will do that, I wished that
it could be done from an XSD or/and XML file. But both are still not
possible. It is a wish from the first moment from many dotNet developers.

Cor

"arch" <to********@yahoo.comschreef in bericht
news:11***************@angel.amnet.net.au...
Perhaps I didn't make myself clear. I want to use VB.Net to generate the
SQL for an sql server table. Is this possible? There is no way this can
be done via Transact-SQL or any programming on the SQL Server (than I am
aware of). I was hoping there was some class library or something within
the .Net framework that could do this.

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:OF**************@TK2MSFTNGP05.phx.gbl...
>Arch,

This is a SQL language problem, this newsgroup is about the VB.net
language. Even if you use a tool deditcated for for VB.Net.

By instance in the Managedment Tool for SQL server is this integrated,
however this is than more a question for the newsgroups ab out SQL
programming.

I hope this helps sofar,

Cor

"arch" <to********@yahoo.comschreef in bericht
news:11***************@angel.amnet.net.au...
>>Is there a function or something I can use to generate an sql script for
an object in an sql server. for example, I want to generate the CREATE
TABLE AS .... statement for a table. I don't want to use SMO or DMO but
some kind of .net functionality.



Sep 2 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: lkrubner | last post by:
I have a webserver through Rackspace. I create a domain. I create an FTP user. I upload some files. I create a database called testOfSetupScript and then I create a database user named setup. I...
3
by: Alan | last post by:
Gidday people, I had a bit of a problem this morning. I think I've got it sorted now, but I wonder if anyone can shed some light. I have a plain VBS WHS file that instantiates a component that...
1
by: A.M. de Jong | last post by:
Can I dynamically (from a stored procedure) generate a create table script of all tables in a given database (with defaults etc) a create view script of all views a create function script of all...
7
by: moondaddy | last post by:
I want to dynamically create a JavaScript file and cache it on the client for re-use. I know how to write javascript to a web page from the code behind, but I don't know how to actually create a...
4
by: Miguel Dias Moura | last post by:
Hello, I created a datalist in an ASP.Net / VB page. I display the image and price of a few products. When a user clicks an image I want to load the page "detail.aspx?number=id" and send the...
6
by: Steve Richter | last post by:
I am getting error in a vbscript: ActiveX component cant create object: Excel.Application. The vbscript code is: Dim objExcel Set objExcel = CreateObject("Excel.Application") I am pretty...
0
by: tommie.nygren | last post by:
I am using Visual Studio.NET 2003 Enterprise Architect Edition (according to my IT guy... how do I actually check what version of it I am using?) and SQL Server Developer Edition (8.00.194 for you...
7
by: thisis | last post by:
Hi All, i have this.asp page: <script type="text/vbscript"> Function Body_Onload() ' create the object Set obj = Server.CreateObject("UploadImage.cTest") ' use method of the object...
10
by: AAaron123 | last post by:
I want to create a database with one table on the host. I can't user SQL Server Management Studio to do it so I guess I have to do it programmatically. I have in mind that in the session start...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.