is there any way to get the query of existing table?

Question

is there any way to get the query of existing tableunfortunatly i lost my queries in sql server

Sourabh Somani · Answer

yeah you can get if table is exists than Open SQL Server Login into server Select Database > Task > Generate Script Now One Dialog box will be open. select tables which data you want to retrieve Now if 2012 Sqlserver is there than select advance option of is 2008 then select script data as true Now Select ok > next > next and you will get your data