Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
a_r_satish
Yak Posting Veteran
84 Posts |
 Posted - 2006-02-17 : 01:42:54
|
| Hi,Though simple, I need to find the create statement for a table in the same format as sp_helptext displays for the procedure.In the sp_help i am unable to find the references/ foreign key details. Is there any built in solution for this???Thanks in advance.Regards,satish.r |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-17 : 01:47:30
|
| It is not available via sp_helptext. However you can use Enterprise Manager, select your table and right click to generate sql script----------------------------------'KH'Time is always against us |
 |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-02-17 : 01:50:58
|
| Hi,You can use Enterprise Manager to generate a script for the Table. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
find the create statement for a table