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.
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.
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.