Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi, I have created a table,index

Status
Not open for further replies.

rama2305

Programmer
Jul 16, 2001
1
US
Hi,

I have created a table,indexes,triggers and constraints by querries. I have lost the querries. Can I regenerate the querry from the systables/system stored procedure by any way?

Any help n this regard will be highly appriciated.

Regards
Rama
 
yeh you can, Use Enterprise Manager.

Run Enterprise Manager, Then select(HighLight) the Table you want to script, RIGHT click on the selected table then select ALL TASK, then choose GENERATE SQL SCRIPTS, you will have a screen poped up, Select the options tab and select the details you want to script.

dbtech
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top