Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

data in a sql server table

Posted on 2009-12-21
2
Medium Priority
?
138 Views
Last Modified: 2012-05-08
sp_columns person
displays table info for table person


is there a query so result window=
CREATE TABLE person
     (
        num               INT              NOT NULL  ,
        firstname         VARCHAR(20)          NULL  ,
        lastname          VARCHAR(30)          NULL  ,        
        gender_code       VARCHAR(1)           NULL  ,
        birth_dttm        DATETIME             NULL  ,  
        inactive_date     DATETIME             NULL  ,
        CONSTRAINT PK_Person PRIMARY KEY CLUSTERED (num ASC) ON [PRIMARY]
     )
GO
0
Comment
Question by:rgb192
2 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 2000 total points
ID: 26100737
the easiest option will be  generate a query by right clicking the table -> tasks -> generate scripts
0
 
LVL 1

Author Closing Comment

by:rgb192
ID: 31668783
easy
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question