| |

VerySource

 Forgot password?
 Register
Search
View: 930|Reply: 1

Questions about database filegroups

[Copy link]

1

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 Chile

Post time: 2020-1-18 13:20:01
| Show all posts |Read mode
alter database Northwind
                add filegroup SECONDARY
                go

alter database northwind
add file
(name = scndr,
filename = 'f:\nthwndScnd',
size = 1Mb,
maxsize = 10Mb,
filegrowth = 10%)

use northwind
go
                CREATE TABLE tbl1
                (col1 int CONSTRAINT pk_column01
                                    PRIMARY KEY
                                    WITH FILLFACTOR = 50
                                    ON SECONDARY, --I would like to ask whether the index is added to the file group secondary, or is this table placed in the secondary?
                col2 int
                )
Reply

Use magic Report

0

Threads

114

Posts

69.00

Credits

Newbie

Rank: 1

Credits
69.00

 China

Post time: 2020-1-24 00:45:01
| Show all posts
Primary key constraints.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list