if im asked to create a database and then create a schema in the model database would it simply be
my database is called db1
and the script would be
create schema db1?
and later after creating a schema i would like to create a table called tb1 within that schema db1
would it just be Create table db1.tb1?
finally if i were to create a table very similar to
how would i determine the data types, properties constraints, primary keys, foreign keys, checks, references
Can you provide a sample
create table for the sys.database_files view?