I could have scripted the existing database to create a new one, but that required ... IS NOT NULL ORDER BY TABLE_SCHEMA,TABLE_NAME The Show Script button generates the actual T-SQL script to be used ...