Hi, Its pretty simple. Just write this in the SQL Query Analyzer : ------------------------------------------------------------------ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id (N'dbo.TABLENAME') AND type='T') DROP TABLE dbo.TABLENAME GO CREATE TABLE dbo.TABLENAME([COL1] DATATYPE, [COL2] DATATYPE)) GO ------------------------------------------------------------------
--- In [EMAIL PROTECTED], Necta - <[EMAIL PROTECTED]> wrote: > > Hi, > > I would like to check if a table exist. If yes it is not, then creat one, if yes than allowed to create one.Anyone pls kindly give any clue. Thanks. > > TQ > > > --------------------------------- > Do you Yahoo!? > New and Improved Yahoo! Mail - Send 10MB messages! > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
