create table from view metadata

Question

create table from view metadata

Shambhu Rai 1,411

Hi Expert,

how we can create table from view metadata

create view as select col1 from table 1

how we can create table from above view

tried create table as select * from view

LiHongMSFT-4306 31,616 Reputation points

2023-02-16T07:13:14.29+00:00

Hi @Shambhu Rai

Is this issue solved now? If you have any questions, please feel free to share with us.

And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

Thanks for your understanding!

3 answers

Your answer

LiHongMSFT-4306 31,616 Reputation points

2023-02-16T07:13:14.29+00:00

Hi @Shambhu Rai

Is this issue solved now? If you have any questions, please feel free to share with us.

And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

Thanks for your understanding!

Answer 1

Alberto Morillo 35,401 MVP Volunteer Moderator

Maybe what you need is SELECT INTO to create the table for you.

SELECT * INTO NewTable
FROM dbo.View

Refresh SSMS to see your table has been created.

You can also get the information related to each column of the view by running the following query:

SELECT * FROM information_schema.columns WHERE table_name = 'VIEW_NAME'

Shambhu Rai 1,411 Reputation points

2023-02-02T17:39:44.0666667+00:00

NO. i do not want to copy data but the Metadata only to create table
Alberto Morillo 35,401 Reputation points MVP Volunteer Moderator

2023-02-02T19:10:36.5866667+00:00

I updated my answer. Hope that information helps you create the table based on the View schema columns.
Shambhu Rai 1,411 Reputation points

2023-02-02T19:12:36.6033333+00:00

first try and then you can answer it
Alberto Morillo 35,401 Reputation points MVP Volunteer Moderator

2023-02-02T19:58:38.8433333+00:00

It works for me.

There you see the column names and the data types.
Shambhu Rai 1,411 Reputation points

2023-02-02T20:36:13.21+00:00

table_name does not take view
Alberto Morillo 35,401 Reputation points MVP Volunteer Moderator

2023-02-02T20:38:37.9833333+00:00

Calendar in my database is a view.

Answer 2

Shambhu Rai 1,411

suggestion please

Answer 3

LiHongMSFT-4306 31,616

Hi @Shambhu Rai

If you only want the view structure, then try this:

SELECT * INTO NewTable
FROM your_view
WHERE 1=2

Best regards,

Cosmog Hong

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

create table from view metadata

3 answers

Your answer