why does the primary filegroup needs brackets in alter statement?

Question

why does the primary filegroup needs brackets in alter statement?

invaliddba

Default port

Points: 1450
More actions
May 14, 2011 at 10:10 am

#236112

In the below statement , why does primary needs to be enclosed in square brackets.?
ALTER DATABASE Employee
MODIFY FILEGROUP [PRIMARY] --- why are the square brackets needed here?
DEFAULT

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

invaliddba (5/14/2011)
In the below statement , why does primary needs to be enclosed in square brackets.?
ALTER DATABASE Employee
MODIFY FILEGROUP [PRIMARY] --- why are the square brackets needed here?
DEFAULT

Because PRIMARY is a Keyword you must enclose it in square brackets.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 2

Square bracket define when name of the object is like

1-jahanzaib is not need to define brackets

2-[jahan-zaib] is need to define in backet

My Blog
www.aureus-salah.com