qr11
Reputation: 441
SQL Server : get query of created table in Management Studio
I have a table in a database created by constructor. Is it possible that I can somehow get the SQL query that was used to create this table?
Upvotes: 1
Views: 471
Answers (1)
PeterRing
Reputation: 1797
Sure, right click on the table in the MS. "Script table as" -> "Create to" ->New query editor window.
Upvotes: 4
Related Questions
- Show create table tablename in SQL Server
- Can't see created tables in Object Explorer - Microsoft SQL Management Studio
- Create Table query in SQL Server
- Create a table with SQL from Query result in SSMS
- view created table in microsoft sql server
- How to view query that was used to create a table?
- How to find the query for creating a table in SQL Server 2008
- Get Table CreateBy attribute from sys.tables
- How to get the "CREATE TABLE" query?
- show Create commands for table in SQL Management Studio (2008)