def temporary_clone_script(self):
        """Sql script to create a temporary clone table

        Note:
            The temporary table only copies the schema and not any data
        """

        # We don't need to use schema for temp tables
        table_name = self.table_name + '_temp'

        # Create a list of column definitions
        columns = comma_seperated(
            ['%s %s' % (c.column_name, c.column_type) for c in self.columns()])

        if self.primary_keys:
            sql = """CREATE TEMPORARY TABLE {table_name} (
                        {columns},
                        PRIMARY KEY( {primary_keys} )
                  )""".format(
                  table_name=table_name, columns=columns,
                  primary_keys=comma_seperated(self.primary_key_names))
        else:
            sql = """CREATE TEMPORARY TABLE {table_name} (
                        {columns}
                  )""".format(
                  table_name=table_name, columns=columns)

        return SqlScript(sql)
dataset/ETHPy150Open coursera/dataduct/dataduct/database/table.py/Table.temporary_clone_script/original