I want to create a Stored Proc wherein I will first find a list of tables to be dropped as :
select tablename from dbc.tables where tablename like '%Test%' and Tablekind = 'T'
and then use a cursor to drop these tables. It will also be good to have a parameter in the Stored Proc that accepts the search pattern of the tables required to be dropped.
Can anyone please help ?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.