How to view query that was used to create a table?
Topman
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.
Sergey Kalinichenko
- Connect to your database using SQL Server Manager Studio
- Right-click the table or the view in the Object Explorer panel
- From the context menu choose Script Table as.../CREATE to.../< SomeDestination >
- Choose a destination (a file, the clip board, etc.)
This would give you access to the DDL SQL that can be used to create this table.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
How to create a table with query?
- 2
How to create a query on an existing table and build a table(view) with aggregated data and a restriction?
- 3
How to create materialized view for a table?
- 4
How to retrieve the SQL used to create a view in Oracle?
- 5
How to retrieve the SQL used to create a view in Oracle?
- 6
How to used for loop to create table in django form
- 7
MS Access database (2010) how to create temporary table/procedure/view from Query Designer
- 8
How to generate table in the view using query in the controller
- 9
How to query/SELECT from a view table?
- 10
How to create a "Secret"like table view animation?
- 11
How to create expandable table view in ios?
- 12
How to create a list view from a database table?
- 13
How to create a table view Using Backbone collection
- 14
How to create a "Secret"like table view animation?
- 15
How to create a radio button in table view
- 16
How to create a view or computed table using EF
- 17
When select from a derby view will the query used to create the view be executed again?
- 18
How to create an Rx Search view that will filter a recycler view with a query
- 19
How to create table in mdb from dbf query
- 20
How to create dynamic query in data table in R
- 21
How to create table in mdb from dbf query
- 22
how can I get the sql statements used to create a specific table?
- 23
How to use a variable as table name at the time of create table query in MySQL?
- 24
Create a method that returns a set of records FROM different table that can be used as a view
- 25
Create a method that returns a set of records FROM different table that can be used as a view
- 26
How to use count in SELECT query to create a view from multiple tables?
- 27
how to CREATE and UPDATE VIEW in SQL Server 2008 using single query
- 28
How to create select query to view multiple columns for values?
- 29
How to use count in SELECT query to create a view from multiple tables?
Comments