Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

7 essential SQL skills that can help you command a higher paycheck Learn how to tackle big data.

SQL server will allow zero-length strings without issue, as long as your datatype supports it. Just assign the string value of ('') and you're done, no headaches.