Microsoft
70-450 · Question #136
A developer in your organisation has added a new table to the company database called PERSON. However, he has forgotten the table structure and his manager needs to recreate the table in his local…
The correct answer is A. Select Tasks - Script Table as - Create to - File. The Script table option will save table definition as a SQL script which the manager can rerun to create the table in their own database.
Design and implement an optimized data maintenance solution
Question
A developer in your organisation has added a new table to the company database called PERSON. However, he has forgotten the table structure and his manager needs to recreate the table in his local database. What should you do to help? Select the table in SQL Server Management studio and..
Options
- ASelect Tasks - Script Table as - Create to - File
- BSelect Tasks - Script Table as - Select to - File
- CSelect Tasks - Import Data
- DSelect Tasks - Export Data
How the community answered
(33 responses)- A79% (26)
- B12% (4)
- C6% (2)
- D3% (1)
Explanation
The Script table option will save table definition as a SQL script which the manager can rerun to create the table in their own database.
Topics
#SSMS scripting#DDL script#table structure#SQL Server Management Studio
Community Discussion
No community discussion yet for this question.