September 11, 2015 at 5:37 am
Hello every one!!
I am very much new to SQL server, I am sure this question might have been asked umpteen number of times but it is challenging for me...so please excuse..
I am working on SQL SERVER schemas using a plug-in in SQL developer itself now
my requirement is to generate DDL for a table which is part of SQL SERVER schema...
can any one please guide on this as how to achieve this?
Thanks
September 11, 2015 at 5:57 am
Right-click on the table name in SSMS, choose Script Table As and then choose the option that's right for you.
John
September 11, 2015 at 6:02 am
Hi John!!
In your reply you have stated SSMS, I guess it is "sql server management studio" I have explored that option but I don't have privileges to install as it is company provided lap...
can you please provide any other option if there is any?
Thanks for your reply
September 11, 2015 at 7:39 am
If the plug-in you are using doesn't provide any similar functionality, you could do [font="Courier New"]sp_help 'MyTable'[/font]. That wouldn't generate the DDL, but it would provide enough information to enable you to generate it yourself. Alternatively, if you search the internet, you'll no doubt find lots of scripts for generating table DDL.
John
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply