How to view query that was used to create a table?

sql sql-server sql-server-2012-express
Topman picture Topman · Apr 4, 2015 · Viewed 11.4k times · Source

I create about 15 tables and create relationships and constraints among them using Wizard in SQL Server 2012 express

Now i want to see the query that is used to create those tables including relationships and constraints. Can u provide help?

Thank you.

Answer

Sergey Kalinichenko picture Sergey Kalinichenko · Apr 4, 2015
  1. Connect to your database using SQL Server Manager Studio
  2. Right-click the table or the view in the Object Explorer panel
  3. From the context menu choose Script Table as.../CREATE to.../< SomeDestination >
  4. Choose a destination (a file, the clip board, etc.)

Screenshot

This would give you access to the DDL SQL that can be used to create this table.

Related questions

How to prevent 'query timeout expired'? (SQLNCLI11 error '80040e31')

I have a connection to a MS SQL Server 2012 database in classic ASP (VBScript). This is my connection string: Provider=SQL Server Native Client 11.0;Server=localhost; Database=databank;Uid=myuser;Pwd=mypassword; When I execute this SQL command: UPDATE [info] …

Read More
Get .sql file from SQL Server 2012 database

I need to get .sql files from an existing database with SQL Server 2012. Is this possible because all I see in the export option is delimited files. Ex.) I have table1 with 30 records. I need a file that would be …

Read More
Can't create stored procedure with table output parameter

I have this code: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetProfitDeals]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[GetProfitDealsVar2] GO IF EXISTS(SELECT 1 FROM sys.types WHERE name = 'TableOrderType' AND is_…

Read More