SQL Server script to create a database with multiple File Groups
Monday, October 19, 2015
SQL Server Create Schema Script
SQL Server script to create a schema and grant a user or security group SELECT access
SQL Server Create Table Script
Sample SQL Script to create a table with the following requirements:
- Auto Incrementing numeric Primary Key
- Columns with default values (InsertDate and UpdateDate)
- Calculated column (Age)
- Unique constraint to prevent duplicate records
- Check constraint to limit data
- Foreign Key constraint to create data relationship
- Specify File Group for data storage
Subscribe to:
Posts (Atom)