Creating a View with tables only.

• clint_pow

  Say Hey Kid

  Points: 690

  More actions

  October 30, 2008 at 6:46 pm

  #383275

  Hi,

  I would like to ask in Creating Views, can create a view that is table only no datas? Is this possible? And I dont want to add/alter a table from the main database.

  Example :

  Create View Clint

  ( Name char(25),

  Age int,

  )

  Thank you very much.

  CLint

• happycat59

  One Orange Chip

  Points: 29384

  More actions

  October 30, 2008 at 8:39 pm

  #892147

  You could do something like

  Create View Clint AS

  SELECT CONVERT (CHAR(25), Null) AS Name ,

  CONVERT (INT, 0) AS Age

  WHERE 1 = 2

• clint_pow

  Say Hey Kid

  Points: 690

  More actions

  October 30, 2008 at 8:51 pm

  #892148

  Hi,

  Thank you very much got an idea.

  You help and guide me well.

  Regards,

  Clint