generate script of a database

Also knowing what kind of database and driver you are using would be a big help.
 
Are you talking about generating the DDL that created an object within the database?
 
For example, I use oracle so I can call the database procedure
 
dbms_metadata.get_ddl(
object_type IN VARCHAR2,
name IN VARCHAR2,
schema IN VARCHAR2 DEFAULT NULL,
version IN VARCHAR2 DEFAULT 'COMPATIBLE',
model IN VARCHAR2 DEFAULT 'ORACLE',
transform IN VARCHAR2 DEFAULT 'DDL')
RETURN CLOB;
 
by using the select statement
 
SELECT DBMS_METADATA.GET_DDL('TABLE','SCHEMA','MY_TABLE') FROM DUAL;
 
You could then use this to output the sql for all your (schema) table objects by doing
 
SELECT DBMS_METADATA.GET_DDL('TABLE',TABLE_NAME) FROM USER_TABLES;
 
This is specific for Oracle though and would be different for sql server or mysql.