Me neither......
If you want help on this forum, you need to help us help you. A comment such as "I don't understand" is not helpful at all. What do you not understand? How to replace [] with ()? How to add a group by? How to right-click a table and choose Script table as?
So, please, explain your problem in more detail. What did you try, what worked, what didn't work, what Google gave you when you searched for CREATE scripts and so on.
Here's an example of a CREATE script for a table:
Code:
CREATE TABLE [dbo].[Level]
(
[LevelID] [int] IDENTITY(1,1) NOT NULL,
[ProductName] [nvarchar](50) NOT NULL,
[UnitPrice] [money] NOT NULL,
CONSTRAINT [PK_Level] PRIMARY KEY CLUSTERED ( [LevelID] ASC )
)
If you create scripts for your other tables and post them here, we can actually TEST your query and be more helpful.
Imar