How To Generate Script of Existing Table in SQL Server

Question

Hello Sir I want To Know That How To Generate a Script For Existing Table

dharmendr · Accepted Answer

Hi RahulPal Refer the below query Make this suery as stored procedureUSE NorthwindGODECLARE tablename SYSNAMESELECT tablename  39dboEmployees39DECLARE       objectname SYSNAME     objectid INTSELECT       objectname  3939  sname  3939  oname  3939     objectid  oobjectidFROM sysobjects o WITH NOWAITJOIN sysschemas s WITH NOWAIT ON oschemaid  sschemaidWHERE sname  3939  oname  tablename    AND otype  39U39    AND oismsshipped  0DECLARE SQL NVARCHARMAX  3939WITH indexcolumn AS     SELECT           icobjectid         icindexid         icisdescendingkey         icisincludedcolumn         cname    FROM sysindexcolumns ic WITH NOWAIT    JOIN syscolumns c WITH NOWAIT ON icobjectid  cobjectid AND iccolumnid  ccolumnid    WHERE icobjectid  objectidfkcolumns AS      SELECT           kconstraintobjectid         cname  cname

How To Generate Script of Existing Table in SQL Server

Company

Explore

Follow us

Contact Us