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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.