Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to create table in SQL with Constraints
- Thread starter ADoozer
- Start date
This is miscategorized. It should be in the SQL forum with you other post.
I'm assuming this is here because you will wind up running the table generation script from C#. You will need to look in the system tables to identfy all of the constraints that are attached to the table. You will probably need dynamic SQL.
If it is a temp table, or merely for reference, the the constraints may be overkill. If you are doing this a script out for backup or custom "restore" process, then you will want the constraints.
Lodlaiden
A lack of experience doesn't prevent you from doing a good job.
I'm assuming this is here because you will wind up running the table generation script from C#. You will need to look in the system tables to identfy all of the constraints that are attached to the table. You will probably need dynamic SQL.
If it is a temp table, or merely for reference, the the constraints may be overkill. If you are doing this a script out for backup or custom "restore" process, then you will want the constraints.
Lodlaiden
A lack of experience doesn't prevent you from doing a good job.
- Status
Similar threads
- Question
- Locked
- Question