Browse by Tags

All Tags » Generate sql script » table structure (RSS)

Generate SQL Script

--This procedure will generate the structure of the table Create Procedure GenerateScript ( @tableName varchar(100)) as If exists (Select * from Information_Schema.COLUMNS where Table_Name= @tableName) Begin declare @sql varchar(8000) declare @table varchar...