Generating create table script (with indexes, keys, constrains) for all tables in SQL Server database

Question

Hello.
If I run the following script

SELECT so.Name, sc.Text
FROM syscomments sc JOIN sysobjects so ON sc.ID = so.ID

I will get all the create procedure/function scripts. Is there something like this for tables, indexes, keys, and triggers?
Thank you for your help!

Answer 1

Nothing inbuilt.

To do it in T-SQL You'd need to find or write your own script. Example here that might get you started.