0

Hi all,
I have a database with a set of relations created in SQL Server express. Is it possible to view or recreate the sql statements that created the database?

Thanks for your time.

Ryan

3
Contributors
3
Replies
28
Views
4 Years
Discussion Span
Last Post by Reverend Jim
0

HI,
Your question is not so clear to me. I would like to ans it if you give some more informations.
I need to be briefed.
Thanks.

0

Hi,
Sorry if I was unclear RvSon. I have a database (consisting of several related tables) which was created in SQL server. I want to know if it is possible to view the SQL statements that created the database and its tables.
IE:

CREATE DATABASE DB1;
CREATE TABLE Customer;

I only need the SQL code that created the tables and not the code used for data entry.
I hope this has made it clearer.

Thanks for youyr help!
Ryan

1

If you install the (free) Microsoft Sql Server Management Studio then you can right click a database or table and select "SCRIPT ...", then pick an option such as CREATE, DROP, etc and it will generate the required commands to the clipboard or a query window. Instructions on how to install are here.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.