Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 Making tables in database in Management studio

views
     
TStest.php
post Oct 12 2016, 11:38 PM, updated 8y ago

Getting Started
**
Junior Member
55 posts

Joined: Oct 2016
From: Programming for beginner island
this backend version is not supported to design database diagrams or tables in management studio 2014


there another way to bypass this. i forgot how. other than reinstalling other version/lastest version ect. i wan to create new table in database in Management studio SQL 2014
Eventless
post Oct 13 2016, 07:32 AM

Look at all my stars!!
*******
Senior Member
2,641 posts

Joined: Jan 2003
You can use sql commands to directly create the tables that you want(create table).
geekster129
post Oct 13 2016, 07:49 AM

Janitor
******
Senior Member
1,180 posts

Joined: Jan 2007
From: *awaiting GPS accuracy*



Which Microsoft SQL Server version is your database running on?
alien3d
post Oct 13 2016, 09:33 AM

Look at all my stars!!
*******
Senior Member
3,740 posts

Joined: Mar 2009
use heidi la
TStest.php
post Oct 13 2016, 09:40 AM

Getting Started
**
Junior Member
55 posts

Joined: Oct 2016
From: Programming for beginner island
QUOTE(alien3d @ Oct 13 2016, 09:33 AM)
use heidi la
*
i have no idea what is that
TStest.php
post Oct 13 2016, 09:40 AM

Getting Started
**
Junior Member
55 posts

Joined: Oct 2016
From: Programming for beginner island
QUOTE(Eventless @ Oct 13 2016, 07:32 AM)
You can use sql commands to directly create the tables that you want(create table).
*
how do i do that? im still new at this
alien3d
post Oct 13 2016, 09:42 AM

Look at all my stars!!
*******
Senior Member
3,740 posts

Joined: Mar 2009
QUOTE(test.php @ Oct 13 2016, 09:40 AM)
i have no idea what is that
*
http://www.heidisql.com/
but still i prefer sql server management studio.. just download all the latest easy
TStest.php
post Oct 13 2016, 09:45 AM

Getting Started
**
Junior Member
55 posts

Joined: Oct 2016
From: Programming for beginner island
QUOTE(geekster129 @ Oct 13 2016, 07:49 AM)
Which Microsoft SQL Server version is your database running on?
*
im not sure what im looking at

sqlexpress2014

express edition

product version: 12.0.4212.0

Microsoft SQL Server Express (64-bit)

im on windows 10 64bit
TStest.php
post Oct 13 2016, 09:46 AM

Getting Started
**
Junior Member
55 posts

Joined: Oct 2016
From: Programming for beginner island
QUOTE(alien3d @ Oct 13 2016, 09:42 AM)
http://www.heidisql.com/
but still i prefer sql server management studio.. just download all the latest  easy
*
i dl the 2016. but somehow i check my install is 2014(express edition) if i redownload. will all my data/setting will be gone?
alien3d
post Oct 13 2016, 09:46 AM

Look at all my stars!!
*******
Senior Member
3,740 posts

Joined: Mar 2009
QUOTE(test.php @ Oct 13 2016, 09:46 AM)
i dl the 2016. but somehow i check my install is 2014(express edition) if i redownload. will all my data/setting will be gone?
*
setting.. should be not.
TStest.php
post Oct 13 2016, 09:50 AM

Getting Started
**
Junior Member
55 posts

Joined: Oct 2016
From: Programming for beginner island
QUOTE(alien3d @ Oct 13 2016, 09:46 AM)
setting..  should be not.
*
ok MS download before this i just download managemnet studio x64bit. so should i download the rest of the 64bit like express n tools?
alien3d
post Oct 13 2016, 09:53 AM

Look at all my stars!!
*******
Senior Member
3,740 posts

Joined: Mar 2009
QUOTE(test.php @ Oct 13 2016, 09:50 AM)
ok MS download before this i just download managemnet studio x64bit. so should i download the rest of the 64bit like express n tools?
*
just download la.. for me.. me lazy blush.gif
TStest.php
post Oct 13 2016, 09:56 AM

Getting Started
**
Junior Member
55 posts

Joined: Oct 2016
From: Programming for beginner island
QUOTE(alien3d @ Oct 13 2016, 09:53 AM)
just download  la..  for me.. me lazy blush.gif
*
Ok i can skip the other 32 bits n the management studio. i try dl the rest
TStest.php
post Oct 13 2016, 11:07 AM

Getting Started
**
Junior Member
55 posts

Joined: Oct 2016
From: Programming for beginner island
No luck in reisntalling
Eventless
post Oct 13 2016, 10:17 PM

Look at all my stars!!
*******
Senior Member
2,641 posts

Joined: Jan 2003
QUOTE(test.php @ Oct 13 2016, 09:40 AM)
how do i do that? im still new at this
*
Assuming you have no problem in running sql commands, you could read through the link below to find out how to create a table using sql commands.
https://msdn.microsoft.com/en-us/library/ms174979.aspx
Most of the information that you need can be found in the help files.
TStest.php
post Oct 14 2016, 03:04 PM

Getting Started
**
Junior Member
55 posts

Joined: Oct 2016
From: Programming for beginner island
QUOTE(Eventless @ Oct 13 2016, 10:17 PM)
Assuming you have no problem in running sql commands, you could read through the link below to find out how to create a table using sql commands.
https://msdn.microsoft.com/en-us/library/ms174979.aspx
Most of the information that you need can be found in the help files.
*
ya i fix that few reinstall ect ect . now no problem creating table. but if i have no manually do table with the link u gave me im screwed

 

Change to:
| Lo-Fi Version
0.0154sec    0.38    5 queries    GZIP Disabled
Time is now: 29th March 2024 - 06:59 PM