Get the table creation DDL

Hi,
Is there a query I can execute that will give me CREATE TABLE() command
used to create a table?

Thank you.