Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Create Table?

Author  Topic 

HockeyFan
Starting Member

26 Posts

Posted - 2005-12-16 : 14:59:36
Is there a SQL statement for creating a table but not adding any fields to it?
I tried CREATE TABLE test1
which was my intent to create a table called test1.
That didn't work. I tried the reference at Microsoft, but it doesn't show how to do it without creating fields.

X002548
Not Just a Number

15586 Posts

Posted - 2005-12-16 : 15:03:38
No

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-12-16 : 15:14:33

What would you use this table for?



CODO ERGO SUM
Go to Top of Page

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2005-12-16 : 15:59:25
I sense a new verse to "Will it go round in circles" coming...any Billy Preston fans out there?

Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -