PAPA1964
asked on
Creating table on sql server
Hello,
I have very limited knowledge on sql and especially on creating TABLE. I have the following request from a customer to create table on the sql server. The customer just wants the shell of the table to be created where she wants to put data which is in Access database. I have sql server enterprise manager version - 8
ColumnName Type Size
Date Date/Time 8
AllowZeroLength: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 1
ColumnWidth: 1740
DataUpdatable: False
Format: mm\/dd\/yy hh:nn:ss
GUID: {guid {69689C6F-9A73-4373-914D-3 A71FE40F60 1}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 0
Required: False
SourceField: Date
SourceTable: Dwnlds06
Column name Type size
Svc ID Text 50
AllowZeroLength: True
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {F8F8E05D-BD05-4145-885C-0 15B34EF11B B}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1
Required: False
SourceField: Svc ID
SourceTable: Dwnlds06
UnicodeCompression: False
There are few more columns and they have almost the same specifics. How do I create a table with these specifics on the Sql server. I have created simple table with limited specifications before. But for these columns I do not see where I can specify these characters. Hope you can help me
I have very limited knowledge on sql and especially on creating TABLE. I have the following request from a customer to create table on the sql server. The customer just wants the shell of the table to be created where she wants to put data which is in Access database. I have sql server enterprise manager version - 8
ColumnName Type Size
Date Date/Time 8
AllowZeroLength: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 1
ColumnWidth: 1740
DataUpdatable: False
Format: mm\/dd\/yy hh:nn:ss
GUID: {guid {69689C6F-9A73-4373-914D-3
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 0
Required: False
SourceField: Date
SourceTable: Dwnlds06
Column name Type size
Svc ID Text 50
AllowZeroLength: True
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {F8F8E05D-BD05-4145-885C-0
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1
Required: False
SourceField: Svc ID
SourceTable: Dwnlds06
UnicodeCompression: False
There are few more columns and they have almost the same specifics. How do I create a table with these specifics on the Sql server. I have created simple table with limited specifications before. But for these columns I do not see where I can specify these characters. Hope you can help me
ASKER
Thanks for your response. What about the these specifics? -
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {F8F8E05D-BD05-4145-885C-0 15B34EF11B B}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1
Required: False
I did create the table successfully.Are these specifics in default? What is GUID? Sorry if I am asking stupid questions.
Thanks a lot
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {F8F8E05D-BD05-4145-885C-0
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1
Required: False
I did create the table successfully.Are these specifics in default? What is GUID? Sorry if I am asking stupid questions.
Thanks a lot
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Column1 <datatype> , Col2 <Datatype> ... )
CREATE TABLE Dwnlds06 (
[date] datetime NULL ,
[SvcID] varchar(50) NULL )