Developer forum

Forum » Development » Generate Create Table sql

Generate Create Table sql


Reply

Hi is it possible to generate an sql file to create tables in another database from the ms sqladmin interface?

 

I dont need the data , just the structure of the tables.

 

- Sune


Replies

 
Reply

Sure, right click the table and choose "Script Table as" -> "CREATE to" -> "New Query Editor Window".

 
Reply
Thanks. However I need it in the online interface at https://sqladmin.dynamicweb.dk/ Is there any possiblilty of making the same action there or backing up the DB and then doing it locally?
I also have the very same tables in an Access Database if its possible to do it from there?

- Sune

 

 
Reply

Sure, you can script your back up, but it would be placed on the SQL server, which there's no access to, so I wouldn't recommend it.

 

You could upsize the Access database, but that won't make any CREATE TABLE scripts until you right click the newly created tables as explained previously.

 

I would recommend to contact our support team through heldesk and have them supply you with a backup file.

 
Reply

Ok perhaps I'll try that

 

thanks

 

- Sune

 
Reply

No problem

 

You must be logged in to post in the forum